The Business Master (3rd Edition)

home *** CD-ROM | disk | FTP | other *** search

/ The Business Master (3rd Edition) / The Business Master (3rd Edition).iso / files / business / dayoinv / dayoid.exe / DAYOINV.DOC < prev next >

Wrap

Text File | 1992-06-02 | 451.6 KB | 5,713 lines

╔════════════════════════════════════════════════════════════════════════════╗ ║ ║ ║ ║ ║ ║ ║ █▄██████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ █▀██████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║ ║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║ ║ ║ ║ ║ ║ ║ ║ ███░ █░ █░ █░█░ ██░ █░ █░ ███░ ▄█▄ ███░ █░ █░ ║ ║ █░ ██░█░ █░█░ █░ ██░█░ █░ █░█░ █░█░ █░ █░ ║ ║ █░ ██░█░ █░█░ █░ ██░█░ █░ █░█░ █░█░ ▀█░█▀ ║ ║ █░ ████░ █░█░ ██░ ████░ █░ █░█░ ██▀ █▄█░ ║ ║ █░ █░██░ █░█░ █░ █░██░ █░ █░█░ ███░ █░ ║ ║ █░ █░ █░ ▀█▀ █░ █░ █░ █░ █░█░ █ █░ █░ ║ ║ ███░ █░ █░ █░ ██░ █░ █░ █░ ▀█▀ █ █░ █░ ║ ║ ║ ║ ║ ║ DAYO INVENTORY, PURCHASING, RECEIVING, VENDORS ║ ║ ║ ║ ║ ║ ║ ║ Copyright (c) 1987-92, TJS LAB, PO Box 585366, Orlando, Florida 32858-5366 ║ ║ ║ ║ ║ ║ ║ ║ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ║ ║ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ S ║ ║ ▓▓ ▓▓ ▄▓▓▓▄ ▀████▀▀ ▀████████████ O ║ ║ ▓▓ ▓▓ ▓▓ ▀▀ ███████████ F ║ ║ ▓▓ ▓▓ ▓▓ ▀▓▓▓▄ Specializing In ▐█████████▌ T ║ ║ ▀▓▓▓▀ ▓▓ MicroComputer ██████████ C W ║ ║ ▀▓▓▓▀ & LAN █████■████▌ O A ║ ║ Applications ▐███████████ N R ║ ║ ┌─┐ ┌─┐ ███████████▌ S E ║ ║ ▀▓▓ ▓ ▀▓▄▓▓▓▄ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ U ║ ║ ▓▓ ▓▓▓ ▓▓ ▓▓ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ L & ║ ║ ▓▓ ▄▓ ▓▄ ▓▓▓▓▓ ░█░ └───╜ ░█░ ███▄▄███ T ║ ║ ▓▓ ▓▓▓▓▓ ▓▓ ▓▓ █████ ░█░ █████ ▀█████▌ I ║ ║ ▓▓▓▓ ▄▓ ▓▄ ▓▀▓▓▓▀ █████ ▀▀▀█ N ║ ║ █ G ║ ║ PO BOX 585366, ORLANDO, FLORIDA 32858-5366 ▄▄▄▄▀ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO Inventory, TJS LAB, Inc. ■ SOFTWARE SUPPORT POLICY 1. TJS LAB does not support users of unregistered DAYO products with the exception of installation questions. 2. Support (included with registration) remains in effect for 3 months after date of purchase. 3. Support is available through the following methods: - Phone: (407) 292-4708 - U.S. Mail: TJS LAB, Inc., PO Box 585366, Orlando, FL 32858-5366 - Compuserve Easyplex: 76367,1401 4. Any errors ("bugs or features') in the program will be corrected and the 'fix' sent promptly (via modem if possible). DAYO Inventory, TJS LAB, Inc. Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 1......INTRODUCTION 1......FEATURE HIGHLIGHTS: 2......COPYRIGHT/LICENSE 2......DISCLAIMER 2......REQUIREMENTS *** 3......SETUP 3......MAIN MENU 4......DAYO INVENTORY, PURCHASE ORDER & RECEIVING FLOW: 5......INITIAL DATA ENTRY 5......PASSWORD/NAME 6......INVENTORY 7...... FULL SCREEN EDIT 8...... WAREHOUSES 10...... INVENTORY ADJUSTMENTS 10...... ADD NEW ITEM 10.1.... EXAMPLE OF NEW ITEM SCREEN 11...... DELETE AN ITEM 11...... RESET THE ONORDER FIELD 11...... VIEW VENDOR INFORMATION 12...... EXPANDED ITEM INFORMATION 12...... ALTERNATE/MULTIPLE VENDORS 13...... FIND ITEMS 14...... ITEM COSTING 15...... COSTING OPTIONS 15...... COMPUTER THE AVERAGE COST FOR ALL ITEMS 16...... COMPUTE THE AVERAGE COST FOR SINGLE ITEM 16...... MANUALLY COMPUTE THE AVERAGE COST FOR AN ITEM 17...... POST AVERAGE COST TO COST FOR SINGLE ITEM 18...... POST ALL POSITIVE AVERAGE COST TO CURRENT COST 19...... POST ALL AVERAGE COST PROGRESS GRAPH 20...... ZERO ALL AVERAGE COSTS 21...... COMPUTE THE REAL COST FOR ALL ITEMS 22...... MANUALLY COMPUTE THE REAL COST FOR SINGLE ITEM 23...... POST REAL COST TO COST FOR SINGLE ITEM 24...... POST ALL POSITIVE REAL COST TO CURRENT COST 25...... ZERO ALL REAL COSTS 25...... COMPUTE THE AVERAGE & REAL COST FOR ALL ITEMS 25...... COMPUTE AND POST THE AVERAGE COST FOR ALL ITEMS 25...... COMPUTE AND POST THE REAL COST FOR ALL ITEMS 26......RECEIVING 26...... BROWSE PO DETAIL ITEMS - F3 27...... BROWSE RECEIPTS - F4 27...... RECEIVE PO 28...... RECEIVE PO DETAIL ITEM 29...... EDIT PO LINE ITEM DATA 29...... SERIAL NUMBERS DAYO Inventory, TJS LAB, Inc. Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 30...... LAST CHANCE TO ABORT RECEIVING PROCESS 31...... EXAMPLE OF A PRINTED RECEIVER 32...... EXAMPLE OF INVENTORY TAGS: 33......VENDORS 35......PURCHASE ORDERS 36...... BROWSE PURCHASE ORDER DETAIL LINE ITEMS 38...... PRINT PURCHASE ORDER 38...... EXAMPLE OF A PURCHASE ORDER (next page) 40...... ADD/CREATE A NEW PURCHASE ORDER 40...... RESET THE PURCHASE ORDER SUBTOTAL 42...... PURCHASE ORDER NOTES (PO NOTES) 43......REPORTS 44...... INVENTORY ADJUSTMENTS REPORT 44...... EXPANDED INVENTORY REPORT 45...... AVAILABLE INVENTORY REPORT 45...... INVENTORY WAREHOUSE REPORT 46...... INVENTORY REORDER REPORT 46...... INVENTORY MOVEMENT REPORT 47...... VALUATION EXPANDED REPORT 49...... INVENTORY TAGS 49...... PURCHASE ORDER HEADER REPORT 50...... PURCHASE ORDER DETAIL REPORT 50...... PURCHASE ORDER HEADER REPORT - SPECIFIC WORK ORDER 51...... PURCHASE ORDER DETAIL REPORT - SPECIFIC WORK ORDER 51...... VENDORS REPORT 52...... VENDORS ADDRESS LABELS 53...... GRAPH - TOP 10 VENDORS 55...... RECEIVING REPORT 55...... DAYO DATABASE SUMMARY REPORT 56...... DAYO CONFIGURATION SETTINGS REPORT 57...... PRINTER DRIVER (SETUP) 57...... PRINTER DRIVER OPTIONS 58...... CHANGE DEFAULT PRINTER 59...... FULL SCREEN EDIT - F2 59...... PRINTER DRIVER DATABASE FIELD DEFINITIONS 60...... VIEW REPORTS ON SCREEN 61...... REPORT VIEWING SCREEN 62......CONFIGURATION 62...... CONFIGURATION LISTING 63...... COMPANY NAME 63...... COMPANY ADDRESS 63...... COMPANY TELEPHONE 63...... STANDARD SALES TAX 63...... LAST PURCHASE ORDER NUMBER 64...... PRINT RECEIVERS/KEY RECS DAYO Inventory, TJS LAB, Inc. Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 64...... LAST RECEIVER NUMBER 64...... PRINT INVENTORY TAGS 65...... REPORT PRINTER TYPE 65...... REPORT PRINTER PORT 65...... PURCHASE ORDER PRINTER TYPE 66...... PURCHASE ORDER PRINTER PORT 66...... RECEIVER PRINTER PORT 66...... INVENTORY TAGS/LABELS PRINTER PORT 66...... POST RECEIVER COST TO THE INVENTORY 67...... APPLY A REAL COST FACTOR TO RECEIPTS OF ITEMS 67...... AUTOMATIC DAILY INDEXING 67...... VISUAL INDEXING 68...... ALLOW BROWSE EDITING 68...... DISPLAY WAREHOUSE VALUES 68...... CURRENT DIRECTORY DATABASE LOCATION 69...... GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY 69...... CLOSE & DELETE FILLED PURCHASE ORDERS 69...... PRINT VENDITEM OR ITEM ONTO PURCHASE ORDER 69...... RECORD SERIAL NUMBERS UPON RECEIPT OF PRODUCT 70...... AUTOMATIC GL POSTING 71...... EDIT CLASS CODE RECORD 71...... ADD NEW CLASS CODE RECORD 72...... FIND CLASS CODE 73...... DEFAULT INVENTORY ITEM TYPE CODE 73...... DEFAULT INVENTORY ITEM CLASS CODE 73...... COLOR MONITOR 73...... COLOR INTENSITY 74......MISCELLANEOUS ROUTINES 74...... MISC ROUTINES MENU: 75...... APPEND FROM 77...... BROWSE DATABASES 79...... COPY (.DBF) TO 81...... CREATE DATABASE 83...... DELETE RECORDS 84...... ERASE FILE 84...... EXIT TO DOS 85...... INDEX A DATABASE 86...... LIST FIELDS 89...... MODIFY DATABASE 90...... PACK DATABASE 91...... RECALL RECORDS 91...... RETURN TO MENU 91...... RUN (DOS COMMAND) 92...... SIMPLE EDITOR 93...... SORT DATABASE 94...... TYPE (PRINT) FILE 95...... ZAP DATABASE DAYO Inventory, TJS LAB, Inc. Table of Contents Page Subject ──── ────────────────────────────────────────────────────────── 97......HELP SCREENS 98...... EXPANDED HELP 99...... USER DEFINED & INPUTTED HELP SCREENS/MESSAGES 100...... VIEW DOCUMENTATION ON SCREEN 101......DAYO INVENTORY MAINTENANCE & QUIRKS 103......FILES 105......DATABASE STRUCTURES 111......DATA DICTIONARY 115......TJS 'Computer' LAB DAYO Inventory, TJS LAB, Inc. Page: 1 DAYO INVENTORY Copyright (c) 1989,1991 TJS LAB, Inc. ■ INTRODUCTION DAYO Inventory is a Multiuser Inventory Control, Purchasing, and Vendor Maintenance application. It can also be used on a 'standalone' personal computer. Use DAYO Inventory to create and maintain an inventory of any product. Create and print purchase orders on a standard printer or a Hewlett Packard LaserJet (tm). Receive purchase orders into inventory, with the option of printing receivers ('key recs'), and inventory tags/price labels. Maintain a Vendors database complete with the vendors purchasing history. With the exception of the initial and ongoing data entry of new product and vendors, DAYO Inventory is totally menu driven. Since DAYO Inventory is multiuser, it is capable of operating on most of the PC based networks, ie: Novell (tm). Other features include Reports, Labels, Lists, and a Graph. A simple database management module is also included to provide you with additional means to modify, view, and report your data. The ability to upgrade your system is available with the addition of supporting DAYO products (ie: DAYO POS, DAYO EOP, DAYO AP, and more...). Very little setup is required to get this application running. DAYO databases are all dBase (tm) compatible. ■ FEATURE HIGHLIGHTS: General: Reports: Menu Driven Inventory Multiuser Expanded With Total Warehouse Qty Unlimited Users Available Only Items with Qty System Maintained Fields Warehouse By Warehouse By Item Dbase (tm) Compatible ReOrder Based On the STOCKLEVEL Field Source Code License Movement Sales as Recorded in PTDSOLD Tags Price/Label Main Modules: Purchase Orders Inventory Header Open/Closed/Both Purchasing Detail Open/Closed/Both Vendors Vendor Receiving Standard Complete Vendor Record Misc DBMS Routines Labels Vendor Mailing Labels Reports Graph Top 10 Vendors Receiving A Simple DBMS: Standard Complete Receiving Record Create Databases Database Status Summary of Records and Bytes Edit Databases Config Status Configuration Status Settings Create Simple Reports Costing Append Files Copy Files Simple Editor DAYO Inventory, TJS LAB Page: 2 ■ COPYRIGHT/LICENSE This manual and software is copyrighted with all rights reserved by TJS LAB. No copying of this manual or software is authorized without the prior written consent of TJS LAB. An exception to this rule is the making of backup copies of registered software disks. No RESALE of any part of the source codes is authorized without the prior written consent of TJS LAB. TJS LAB retains all rights to DAYO INVENTORY software, documentation, and source codes. ■ DISCLAIMER No warrant is made that this software will work in all environments, or with all resident programs and hardware configurations. TJS LAB has tested this software in many environments and found it to perform as expected, however, this software is licensed "AS IS". TJS LAB will not be liable for any damage done to your data, hardware and/or software systems as a result of using DAYO INVENTORY. ■ REQUIREMENTS *** IBM or Compatible CPU 640K memory * DOS 3.3 or above (Will NOT work under any earlier version!) Printer - HP Laser (tm) or Epson (tm) compatible (either or both) Hard Disk - Approximately 1 Meg (1,000,000 bytes), available disk space for each major DAYO module DAYO Inventory, TJS LAB Page: 3 ■ SETUP To setup DAYO Inventory, use the SETUP program supplied on the MENU or Update & Conversion diskette, or copy the contents of the DAYO Inventory floppy disks into a directory on your hard disk (ie: \DAYOINV), then 'uncompress' (ie: PKunzip ) them. When running DAYO Inventory for the first time, it will create all the database, index, and configuration files it requires for operation. If other DAYO modules are being used, be sure to enter the location of these databases into the DAYO Inventory configuration. Type and enter 'DAYOI' at the DOS prompt to run the program (ie: C:\DAYOI ). On your initial 'run' through DAYO Inventory, you will be prompted to verify and/or change the defaults and system configuration. There are many key configuration items. Read about the Configurations for more information. *** Your CONFIG.SYS file must have the buffers set to a minimum of 10, and your files must have a MINIMUM setting of 99! Failure to edit the CONFIG.SYS file is the #1 cause for DAYO installation problems! A CONFIG.SYS file is created if there is a problem detected, in the directory that this DAYO module is being run in. You may copy this file into your root/boot drive. Refer to your DOS manual for more information on the CONFIG.SYS file! ■ MAIN MENU - After getting through the free 'advertising' and 'register me' screens you are presented with the MAIN MENU, ie: DAYO INVENTORY Version 4.00 TJS LAB, Inc. ┌─────[June 1992]────┐ Copyright (c) 1989-1992, All Rights Reserved │S M T W T F S │ ╓────────────────────╖ ├────────────────────┤ ║ 1 INVENTORY ║ ██▄████░ ▄███▄ ██░ ██░ ██████░ │ 1 2 3 4 5 6│ ╟────────────────────╢ ██░ ██░ ██░██░ ██░ ██░ ██░ ██░ │ 7 8 9 10 11 12 13│ ║ 2 RECEIVING + ║ ██░ ██░ ██░██░ ▀████▀ ██░ ██░ │14 15 16 17 18 19 20│ ╟────────────────────╢ ██░ ██░ ██▀▀▀██░ ▀██▀ ██░ ██░ │21 22 23 24 25 26 27│ ║ 3 VENDORS ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ │28 29 30 │ ╟────────────────────╢ █▀█████░ ██░ ██░ ██░ ██████░ │ │ ║ 4 PURCHASE ORDERS ║ └────────────────────┘ ╟────────────────────╢ ╓────────────────────────────────────────────────╖ ║ 5 REPORTS ║ ║ DAYO INVENTORY STATISTICS ║ ╟────────────────────╢ ╟────────────────────────────────────────────────╢ ║ 6 CONFIGURATION ║ ║ DATABASE NAME RECORDS SIZE ║ ╟────────────────────╢ ╟────────────────────────────────────────────────╢ ║ 7 MISC ROUTINES ║ ║ INV.DBF Inventory 228 81K ║ ╟────────────────────╢ ║ POH.DBF PO Header 37 32K ║ ║ 8 EXIT ║ ║ POD.DBF PO Detail 168 25K ║ ╚════════════════════╝ ║ VENDORS.DBF Vendors 2 3K ║ Select Option ║ REC.DBF Receiving 18 4K ║ ████░ ██▄ ██░ ██░ ██░ ║ INVADJ.DBF Adjustments 74 13K ║ ██░ ████░██░ ██▄ ▄██░ ║ WAREHOUS.DBF Warehouse Qty 0 1K ║ ██░ ██░████░ ██▄██░ ║ WARENAME.DBF Warehouse Names 11 1K ║ ████░ ██░ ▀██░ ███░ ╚══════════[ Press Alt F9 To Reindex ]═══════════╝ DAYO Inventory, TJS LAB Page: 4 Building a 'MAIN MENU' can be considered a work of art, or hard labor. This Main Menu was a bit of both! The actual menu is the left 3rd of the screen. There is a calendar on the upper right. The lower right of the screen contains the DAYO DATABASE STATISTICS: database name, record count, and database size. The 'art' is that DAYO symbol/sign displayed at the upper and center of the screen. From the MAIN MENU you can enter any of the 7 main modules, or exit DAYO Inventory to return to DOS. DAYO Inventory was built around 2 basic 'rules': 1. All inventory items will be procured from vendors through purchase orders. 2. All purchase orders will be received into the inventory. Keeping strict adherence to these 2 basic rules will help insure proper recording of your dollars spent on product, as well as a firm handle on inventory control. To further illustrate the cycle of Purchasing & Inventory as it applies to DAYO Inventory, the following flowchart may help. ■ DAYO INVENTORY, PURCHASE ORDER & RECEIVING FLOW: ┌─────────────────┐ │ PURCHASE ORDERS │ ├─────────────────┤ ┌─────────┐ │ Create a │ Send to │ Your │ │ Purchase Order │ ──────────────────────>│ Vendors │ └─────────────────┘ └─────────┘ │ │ Delivered to you │ Adjustments \│/ /│\ ┌────────────┐ │ │ RECEIVING │ │ ├────────────┤ ┌───────────┐ │ Record the │ ───────> Print │ Inventory │<─────────────────────────── │ Receipt of │ Receiver └───────────┘ Posted to the Inventory │ Items from │ │ │ the Vendor │ ───────> Print \│/ └────────────┘ Inventory DAYO BILLING Tag/Label & INVOICING DAYO Inventory, TJS LAB Page: 5 ■ INITIAL DATA ENTRY Go to the Configuration module and type in your name (or company name), and company address. Set the other configuration settings as applicable to your business. The first data entry should be to type all your vendor data into the vendors database (Vendors.dbf). The VENDORS module (from the Main Menu) is an easy-to-use method of 'loading' and maintaining your vendors file. After a vendor is entered into the vendors database, you can then create a purchase order for products from that vendor. Use the PURCHASE ORDERS module to accomplish this next step. New items can be created while in the INVENTORY module, or by receiving new items into the inventory via the PURCHASE ORDERS and/or the RECEIVE module. It is recommended that you enter your items in first, before creating a purchase order. It you elect to create new items by first creating a purchase order, be sure to return to the inventory file to fill in the rest of the inventory record. All the data, in all the DAYO databases can be edited without going through a 'formal' data entry screen. The BROWSE options permit you to edit and/or create new records. This option is available, but it is not recommended in the inventory and purchase order detail database browse screens. There is an option to 'turn off' this capability in the Configuration module. After getting your databases set up, it is recommended that you turn this option off! Data integrity is at stake! Select 'N' at the 'Allow Browse Edit' option in the Configuration Module to prohibit editing of the inventory and purchase order detail records while in the browse screens. ■ PASSWORD/NAME From the main menu you can enter any of the routines/options, but not until you enter your name (or password if using DAYO Passwords): ┌────────────────────────────────────────────────────────────────────────────┐ │┌──────────────────────────────────────────────────────────────────────────┐│ ││ Enter Your Name: George Moonilal ││ │└──────────────────────────────────────────────────────────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 6 ■ INVENTORY The INVENTORY module is provided to allow you to view/edit and maintenance your inventory items. The ability to 'move' quantities between warehouses/locations is also available. All data in the INV.DBF and WAREHOUS.DBF is available for your inspection while in the inventory browse screen. Use the right, left, up, down, page up, page down to view records/fields below and to the right/left of the highlighted field. See the section on HELP SCREEN for more on special keys while in the browse screens. Press Esc to exit back to the Main Menu. Press F1 to bring up a HELP screen. DAYO INVENTORY Version 3.01 TJS LAB INVENTORY ┌─────[June 1991]────┐ ╔══════════════════════════════════════════════════════╗│S M T W T F S │ ║Item: JAR-1 Desc: Regal Jar #1 ║├────────────────────┤ ║Vendor Item: AJ-123456 Vendor: ACME JAR ║│ 1│ ║Onhand: 100 On Order: 30 ║│ 2 3 4 5 6 7 8│ ║PTD Sold: 0 YTD Sold: 0 BO: 0 ║│ 9 10 11 12 13 14 15│ ║Cost: 44.00 Price: 149.99 Retail: 199.99 ║│16 17 18 19 20 21 22│ ║Type: XXX Class: JAR Taxable: Y Serial No: N ABC: A║│23 24 25 26 27 28 29│ ║Stocklevel: 98 Min: 43 Max: 155 ║│30 │ ╚═══════════════════════[ INVENTORY DATABASE BROWSE ]══╝└────────────────────┘ ITEM DESC ONHAND ONORDER BO ──────────────╥───────────────────────────────╥─────────╥─────────╥─────────── JAR-1 ║ Regal Jar #1 ║ 100 ║ 30 ║ 0 JAR-2 ║ Regal Jar #2 ║ 20 ║ 70 ║ 0 JAR-3 ║ Regal Jar #3 ║ 330 ║ 0 ║ 0 JAR-6 ║ Regal Jar #6 WHITE ║ 321 ║ 0 ║ 0 JAR-6A ║ Regal Jar #6 RED ║ 23 ║ 0 ║ 1 JAR-6B ║ Regal Jar #6 YELLOW ║ 12 ║ 100 ║ 0 JAR-6F ║ Regal Jar #6 BLUE ║ 2 ║ 100 ║ 30 Esc (Exit) F1 (Help) F2 (Edit) F4 (Warehouses) Shift F1 (Adjustment) Ctrl N(Add) Ctrl U (Del) Ctrl F1 (Reset) Ctrl F2 (Vendor) Ctrl F10 (Cost) Alt I (Expanded Item Info) Alt V (Alternate Vendors) Find F5 (Item) F6 (Desc) F7 (Vendor) F8 (VendItem) F9 (Type) <INFO> 2/3 DAYO Inventory, TJS LAB Page: 7 ■ FULL SCREEN EDIT If the 'Allow Browse Edit' (from the Configuration module) is set to 'Y', you can press F2 to bring up an edit screen. Note that this option will display up to 42 of the fields in the inventory database (INV.DBF). ┌───────────────────────[ EDIT ITEM - FULL SCREEN EDIT ]─────────────────────┐ │ ITEM: 1004 │ │ DESC: LARGE BOTTLE SIZE: 4 │ │ ONHAND: 300 │ │ ONORDER: 304 │ │ SOLDPTD: 123 │ │ SOLDYTD: 5632 │ │ VENDITEM: SDF1004 │ │ VENDOR: SDF │ │ DATE: 11/26/89 │ │ LASTDATE: 11/28/89 │ │ COST: 492.49 │ │ RETAIL: 3.00 │ │ PRICE: 984.98 │ │ STOCKLEVEL: 400 │ │ TYPE: 4 │ │ CLASS: │ │ TAXABLE: F │ │ SERIALNO: T │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO Inventory, TJS LAB Page: 8 All inventory database (INV.DBF) fields, plus any you add (up to 42), will be presented on the screen for editing. The only type of field that can not be edited is the memo type. ■ WAREHOUSES DAYO Inventory comes with a simple to use warehouse maintenance routine. This routine was created to allow you to place some of your inventory in locations other than the main warehouse quantity field (ONHAND). To operate the warehouse transfer routine, press F4 at the inventory browse screen after highlighting/finding the desired item. Two windows will appear onto the screen. The screen on the upper left is a user maintained file containing the literal name of a warehouse/location aside its 'code'. The window on the right side contains the seven default warehouse/location codes. DAYO INVENTORY Version 3.0 TJS LAB INVENTORY ┌───[February 1991]──┐ ┌──────────────────────────────────────────┐┌─────────────────────┐ T F S │ │ Warehouse Name/Location ││ WAREHOUSE TRANSFERS │──────────┤ │ OnHand Main Warehouse │╞═════════════════════╡ 1 2│ │ LOC1 RETURN TO VENDOR FOR REPAIR ││ Warehouse Qty │6 7 8 9│ │ LOC2 INTERNAL/OFFICE USE ││ Onhand 300 │3 14 15 16│ │ LOC3 DISCONTINUED ││ LOC1 0 │0 21 22 23│ │ LOC4 DAMAGED ││ LOC2 0 │7 28 29 30│ │ LOC5 BUILDING # 1001 ││ LOC3 0 │ │ │ LOC6 IN USE, SHOP FLOOR ││ LOC4 0 │──────────┘ │ LOC7 OUT ON LOAN ││ LOC5 0 │ └──────────────────────────────────────────┘│ LOC6 0 │ SOLDPTD ───────────────╥────────────────────────────│ LOC7 0 │─────────── 1001 ║ LARGE BOTTLE SIZE: 1 │ │ 123 1002 ║ LARGE BOTTLE SIZE: 2 │ │ 123 1003 ║ LARGE BOTTLE SIZE: 3 │ │ 123 1004 ║ LARGE BOTTLE SIZE: 4 │ │ 123 1005 ║ LARGE BOTTLE SIZE: 5 ╞═════════════════════╡ 123 1006 ║ LARGE BOTTLE SIZE: 6 │ Select a Warehouse │ 123 1007 ║ LARGE BOTTLE SIZE: 7 │ with a quantity > 0 │ 123 1008 ║ LARGE BOTTLE SIZE: 8 │ to transfer quantity│ 123 Esc (Exit) F1 (Help) F2 (Edit) F4 (W│ FROM... │ Ctrl N (Add) Ctrl U (Delete) Ctrl F1 (└─────────────────────┘(Vendor) Find F5 (Item) F6 (Desc) F7 (Vendor) F8 (VendItem) F9 (Type) 4/240 Since it cannot be determined what warehouses (if any) you might use, seven default warehouses/locations were created. You can edit/delete/add the warehouse name database records (WARENAME.DBF) from the MISC routines (BROWSE DATABASES option). This database does not need to be maintained in order for DAYO Inventory to operate. DAYO Inventory, TJS LAB Page: 9 If desired, additional warehouses/locations can be added to the warehouse quantity database (WAREHOUS.DBF). Use the MODIFY DATABASE option, from the MISC routines, to add/delete LOCx fields in the warehouse quantity database (WAREHOUS.DBF). All warehouse/location field names must start with 'LOC' and then a number. Insure that you make backups of your databases before attempting any change! Insure that every field name is unique! To 'move' quantity from one warehouse/location (ie: ONHAND to LOC3), press Enter/Return upon a highlighted warehouse field. A prompt will appear upon the screen (if any quantity exists) requesting the transfer amount. This amount can not exceed the warehouse/location total. Highlight the warehouse to receive the quantity, and press Enter/Return to place the quantity in that warehouse/location. DAYO INVENTORY Version 3.0 TJS LAB INVENTORY ┌───[February 1991]──┐ ┌──────────────────────────────────────────┐┌─────────────────────┐ T F S │ │ Warehouse Name/Location ││ WAREHOUSE TRANSFERS │──────────┤ │ OnHand Main Warehouse │╞═════════════════════╡ 1 2│ │ LOC1 RETURN TO VENDOR FOR REPAIR ││ Warehouse Qty │6 7 8 9│ │ LOC2 INTERNAL/OFFICE USE ││ Onhand 300 │3 14 15 16│ │ LOC4 DAMAGED ││ LOC2 0 │7 28 29 30│ │ LOC5 BUILDING # 1001 ││ LOC3 0 │ │ │ LOC6 IN USE, SHOP FLOOR ││ LOC4 0 │──────────┘ │ LOC7 OUT ON LOAN ││ LOC5 0 │ └──────────────────────────────────────────┘│ LOC6 0 │ SOLDPTD ───────────────╥──────────────┌──────────────────────────────────────────────┐ 1001 ║ LARGE BOTTLE │ Enter Amount to be Transferred: 10 │ 1002 ║ LARGE BOTTLE └──────────────────────────────────────────────┘ 1003 ║ LARGE BOTTLE SIZE: 3 │ │ 123 1004 ║ LARGE BOTTLE SIZE: 4 │ │ 123 1005 ║ LARGE BOTTLE SIZE: 5 ╞═════════════════════╡ 123 1006 ║ LARGE BOTTLE SIZE: 6 │ Select a Warehouse │ 123 1007 ║ LARGE BOTTLE SIZE: 7 │ with a quantity > 0 │ 123 1008 ║ LARGE BOTTLE SIZE: 8 │ to transfer quantity│ 123 Esc (Exit) F1 (Help) F2 (Edit) F4 (W│ FROM... │ Ctrl N (Add) Ctrl U (Delete) Ctrl F1 (└─────────────────────┘(Vendor) Find F5 (Item) F6 (Desc) F7 (Vendor) F8 (VendItem) F9 (Type) 4/240 DAYO Inventory, TJS LAB Page: 10 ■ INVENTORY ADJUSTMENTS To 'relinquish' DAYO Inventory items, a inventory adjustments routine is provided by simultaneously pressing either of the shift keys (left or right) and the F1 key. A window prompt will appear below the display of the item data (top left of screen): ┌────────────────────────────────────────────────────────┐ │Item: 1003 Desc: LARGE BOTTLE SIZE: 3 │ │Vendor Item: SDF1003 Vendor: SDF │ │Onhand: 202 On Order: 0 │ │PTD Sold: 123 YTD Sold: 5632 │ │Cost: 369.37 Price: 738.74 Retail: 234.00 │ │Type: 345 Class: 345 Taxable: Y Serial No: N │ │Warehouses Loc1: 0 Loc2: 0 Loc3: 0 │ │ INVENTORY ADJUSTMENT │ │ Cost: 369.37 │ │ Price: 738.74 │ │ Retail: 234.00 │ │ Qty: 10 │ │ Reason: Found in the back room │ └────────────────────────────────────────────────────────┘ You can adjust/change the COST, PRICE, RETAIL fields. The 'Qty' field contains the number of items to be adjusted. To complete the adjustment task, you must enter a REASON! Pressing 'Esc' will abort the operation. One of the main uses of this option will be to remove quantities from the inventory database. An optional DAYO product (DAYO Billing & Invoicing), can also be used to remove inventory quantities (called sales). ■ ADD NEW ITEM To add a new item, simultaneously press the 'Ctrl' and 'N' keys. The first prompt you get will be one for a unique item number. Note, this new inventory number can not already exist in the inventory datase. After entering a unique item, you are prompted to enter a valid vendor number. If you enter a wrong vendor number, or press enter on a blank prompt, a browse selection window will appear onto the screen allowing you to find and select a desired vendor. See Example of New Item Screen next page... DAYO Inventory, TJS LAB Page: 10.1 ■ EXAMPLE OF NEW ITEM SCREEN ╔════════════════════════════════════════════════════════════════════════════╗ ║ Enter a Unique Item Number: NEWITEM ║ ║ Enter Vendor: [ TOM JOHNSON ] ║ ║ ║ ║ Description: DESCRIPTION OF YOUR ITEM! Vendor/Mfg Number: ║ ║ 2nd Desc: ║ ║ INV ║ ║ Cost: 0.00000 Price: 0.00 Class: INV ║ ║ Average Cost: 0.00 Price1: 0.00 Category: 0 ║ ║ Real Cost: 0.00 Price2: 0.00 ABC: ║ ║ Retail: 0.00 Price3: 0.00 Unit: ║ ║ Price4: 0.00 UnitQty: 0 ║ ║ Begin Qty: 0 Price5: 0.00 PackQty: ║ ║ ║ ║ Location: Weight: 0.00 Min: 0 Max: 0 ║ ║ Taxable: Y Serial Number Required: N Non-Standard: N Service/Time: N║ ║ ██░ ██░ █████░ ██░ █░ ██░ ████░ ██████░ █████░ ██░ ██░ ║ ║ ███░ ██░ ██░ ██░███░██░ ██░ ██░ ██░ ███░ ███░ ║ ║ ████░██░ ████░ ██░███░██░ ██░ ██░ ████░ ████████░ ║ ║ ██░████░ ██░ ████░████░ ██░ ██░ ██░ ██░██░██░ ║ ║ ██░ ███░ █████░ ██░ ██░ ████░ ██░ █████░ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) PgDn/PgUp (Save & Exit) 70/207 DAYO Inventory, TJS LAB Page: 11 It is very important that the ITEM, DESC, COST, and VENDOR fields be entered. They are the most critical ones. See the DATABASE DICTIONARY section for more information on the fields. ■ DELETE AN ITEM To delete an inventory item (very dangerous) press Ctrl U. This marks the record for deletion. It can be physically removed with the PACK option from the MISC routine module. When deleting items, be sure that you have no quantity in the ONHAND field of the inventory database (INV.DBF), in any of the LOCx field of the warehouse database (WAREHOUS.DBF), in the purchase order database (POD.DBF), and/or in the receiving database (REC.DBF). ■ RESET THE ONORDER FIELD The ONORDER field in the inventory database (INV.DBF) may get out of adjustment (some may call this a bug, I call it a 'feature'). Press Ctrl F1 to set it to a correct amount. This option zeros out all ONORDER fields in the inventory database (INV.DBF) and recalculates them. It gets the sums from the items not yet received in the purchase order detail database (POD.DBF). ■ VIEW VENDOR INFORMATION Press Ctrl F2 to view the vendor information. If a match to the VENDOR field can be found in the vendors database (VENDORS.DBF) the data will be displayed onto the screen. ┌───────────────────────────────────────┐ │ Vendor: SDF │ │ ONE STOP DEPARTMENT STORE │ │ │ │ 1701 LAST STREET │ │ WUBBLE, FL 32801 │ │ Date: 12/12/89 Last Used: 12/12/89 │ │ Type: A Class: B │ └───────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 12 ■ EXPANDED ITEM INFORMATION Press Alt I to bring up any expanded information about the highlighted item. The option to edit this 30 character wide (no limit lines) field is also present (just type in the changes). ╔═══════════[ Edit Expanded Item Information ]═════════════╗ ║ ║ ║ ███░ █▄ ▄█░ █▄██░ █░ █░ █░ █▄██░ ███░ █▄██░ ║ ║ █░ █▄█░ █░ █░ █▀█░ ██░█░ █░ █░ █░ █░ █░ ║ ║ ██░ █░ ████░ █▄█░ ████░ █░ █░ ██░ █░ █░ ║ ║ █░ █▀█░ █░ █▀ ▀█░ █░██░ █░ █░ █░ █░ █░ ║ ║ ███░ █▀ ▀█░ █░ █░ █░ █░ █░ █▀██░ ███░ █▀██░ ║ ║ Item: JAR-1 Sample Item Description ║ ║ ┌─ This is an example of how you ─┐ The first 4 lines ║ ║ │ can create multiple lines of │ will print onto ║ ║ │ description for a specific │ Purchase Orders ║ ║ └─ item. ─┘ & Work Orders! ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ███░ █████░ ███░ █░ █░ ███░ █░ █░ ███░ ███░ ║ ║ █░ █░ █░ ██░██░ █░ ██░█░ █░ █░█░ ║ ║ █░ █░ ██░ █████░ █░ ████░ ██░ █░█░ ║ ║ █░ █░ █░ █░█░█░ █░ █░██░ █░ █░█░ ║ ║ ███░ █░ ███░ █░ █░ ███░ █░ █░ █░ ███░ ║ ╚══════════════════════════════════════════════════════════╝ ■ ALTERNATE/MULTIPLE VENDORS Press Alt V to bring up a table/database browse of all alternate or multiple vendors for the highlighted item. Each record will contain the item, vendor, comment, and the cost of the item if purchased from that vendor. ╔═══[ Default Vendor: ACME JAR Cost: 44.00 ]════════════════════════╗ ║ █░ █░█░█░█░█████░███░█▄██░█░ ███░ █░ █░███░█░ █░█▄██░███░█▄██░███░ ║ ║ ██░██░█░█░█░ █░ █░ █░ █░█░ █░ █░ █░█░ ██░█░█░ █░█░█░█░ █░█░ ║ ║ █████░█░█░█░ █░ █░ ████░█░ ██░ █▄ ▄█░██░ ████░█░ █░█░█░████░███░ ║ ║ █░█░█░█░█░█░ █░ █░ █░ █░ █░ █▄█░ █░ █░██░█░ █░█░█░█░█░ █░ ║ ║ █░ █░███░███░█░ ███░█░ ███░███░ █░ ███░█░ █░█▀██░███░█░██░███░ ║ ║ ──────────────────────────────────────────────────────────── ║ ║ Item │ Vendor │ Cost │ Comment ║ ║ JAR-1 │ ACME JAR │ 44.00 │ Default Vendor, average jar ║ ║ JAR-1 │ MORO-INC │ 46.00 │ ║ ║ JAR-1 │ JASONCS │ 46.99 │ (very slow in delivering!) ║ ║ JAR-1 │ BRENDAD │ 46.00 │ heavy ║ ║ JAR-1 │ RONI-10002 │ 43.99 │ ║ ║ JAR-1 │ GEORGIAJAR │ 43.00 │ ║ ║ JAR-1 │ SC_JAR │ 55.99 │ Highest quality. Fast delivery ║ ║ JAR-1 │ 100-MORGAN │ 45.30 │ light ║ ║ JAR-1 │ 101-MORGAN │ 45.34 │ light ║ ║ JAR-1 │ 102-MORGAN │ 45.40 │ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) Enter (Make Default Vendor) Ctrl N (Add) DAYO Inventory, TJS LAB Page: 13 ■ FIND ITEMS From the inventory browse screen, you can find an item based on five indexes (item, description, vendor name, vendor item, and type). Press F5 to find/seek an item based on the field: ITEM ┌─────────────────────────────────────────────────────────────┐ │ Enter ITEM: 1237 │ └───────────────────────────────────────────────────TJS LAB───┘ Press F6 to find/seek an item based on the field: DESC ┌─────────────────────────────────────────────────────────────┐ │ Enter DESC: LARGE BOTTLE │ └───────────────────────────────────────────────────TJS LAB───┘ Press F7 to find/seek an item based on the field: VENDOR ┌─────────────────────────────────────────────────────────────┐ │ Enter VENDOR+DESC: SDF │ └───────────────────────────────────────────────────TJS LAB───┘ Press F8 to find/seek an item based on the field: VENDITEM ┌─────────────────────────────────────────────────────────────┐ │ Enter VENDITEM: SDF │ └───────────────────────────────────────────────────TJS LAB───┘ Press F9 to find/seek an item based on the field: TYPE ┌─────────────────────────────────────────────────────────────┐ │ Enter TYPE: A │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO Inventory, TJS LAB Page: 14 ■ ITEM COSTING In an effort to aid DAYO users in determining the 'true' cost of an item, two methods are provided: AVERAGE and REAL. For DAYO's purposes, Average Cost is computed as the average of all receipt costs (from database REC.DBF or 'manually entered'). The REAL Cost is the same as the Average Cost plus the freight for the item is added in. The Average Cost is computed and placed into the field AVGCOST in the database INV.DBF. The Real Cost is computed and placed into the field REALCOST in the same database. The preferred method of costing (in our opinion) is 'real time' average costing. This takes place every time you receive product into inventory and is done automatically. If the configuration setting 'POST RECEIVER COST TO THE INVENTORY' option is set to Yes, then the existing inventory item cost is averaged with the new cost using the following algorithm: New Inventory Cost = ((COST*ONHAND)+(NEWCOST*RECEIVED))/(ONHAND+RECEIVED) ╔══════════════════════════════[ ITEM COSTING ]════════════════════════════╗ ║ This routine assists you in determining the value you wish to use as the ║ ║ actual/current cost for items in the inventory. DAYO inventory items have║ ║ 3 types of Costs: Current (Cost), Average (AVGCOST) and Real (REALCOST).║ ║ The Current Cost (COST) is the field used in all transactions requiring ║ ║ a cost. ║ ║ The Average Cost is the average cost of goods received. Each time items ║ ║ are received into inventory, the new cost of the received items is ║ ║ averaged with the Current Cost to get the new Average Cost. ║ ║ The Real Cost combines the Average Cost with the cost of Freight. ║ ║ Use this routine to do the computation and posting. performed. ║ ║ ║ ║ Select Option -> Compute The Average Cost For All Items ║ ║ Compute The Average Cost For Single Item ║ ║ Manually Compute The Average Cost For An Item ║ ║ Post Average Cost To Cost For Single Item ║ ║ Post All Positive Average Cost To Current Cost ║ ║ Zero All Average Costs ║ ║ Compute The Real Cost For All Items ║ ║ Manually Compute The Real Cost For Single Item ║ ║ Post Real Cost To Cost For Single Item ║ ╚══════════════════════════════════════════════════════════════════════════╝ Esc (Exit) DAYO Inventory, TJS LAB Page: 15 ■ COSTING OPTIONS There are 14 costing options: Compute The Average Cost For All Items Compute The Average Cost For Single Item Manually Compute The Average Cost For An Item Post Average Cost To Cost For Single Item Post All Positive Average Cost To Current Cost Zero All Average Costs Compute The Real Cost For All Items Manually Compute The Real Cost For Single Item Post Real Cost To Cost For Single Item Post All Positive Real Cost To Current Cost Zero All Real Costs Compute The Average & Real Cost For All Items Computer and Post The Average Cost For All Items Compute and Post The Real Cost For All Items ■ COMPUTER THE AVERAGE COST FOR ALL ITEMS Select this option to computer the Average Cost for all items/records in the database INV.DBF. The routine averages all receipts for each item. The receipts data is found in the database REC.DBF. The progress, as with the other options, is displayed onto the screen. ╔════════════════════════════════════════════════════════════════════════════╗ ║ ▄███████░ ██████░ ▄█████▄ ████████░ ████░ ██░ ██░ ▄██████▄ ║ ║ ██░ ▀ ██▀ ▀██░ ██░ ██░ ██░ ██░ ███░ ██░ ██░ ▀ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██▄ ██░ ██░ ██░██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ████░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░██░ ██░ █▀█▄ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ▄ ██▄ ▄██░ ██ ██▀ ██░ ██░ ██░ ███░ ██░ ██░ ║ ║ ▀███████░ ██████░ ▀█████▀ ██░ ████░ ██░ ██░ ▀███████▀ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Computing Average Cost for All Items ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Item Description Cost Received Extended Avg Cost ║ ║ JAR-23 JAR #23 3.00 9 27.00 3.00 ║ ║ JAR-34 JAR #34 4.30 1 4.30 4.30 ║ ║ JAR-34A JAR #34 ALPHA 4.55 1 4.55 4.55 ║ ║ JAR-35 JAR #35 4.05 1 4.05 4.05 ║ ║ JAR-36 JAR #36 3.04 1 3.04 3.04 ║ ║ JAR-55 JAR #55 4.33 10 43.30 4.33 ║ ║ JAR-58 JAR #58 4.05 1 4.05 4.05 ║ ║ JAR-59 JAR #59 4.36 1 4.36 4.36 ║ ║ JAR-63 JAR #63 4.30 1 4.30 4.30 ║ ╚══╡███████┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ┼ ╞═╝ DAYO Inventory, TJS LAB Page: 16 ■ COMPUTE THE AVERAGE COST FOR SINGLE ITEM If you want to compute the cost for a single item, select this option. It will only sum receiving data (from the database REC.DBF) for a desired item. You will only be prompted to enter the item number, then it will 'go out' and compute the Average Cost (like in the previous option): ╟────────────────────────────────────────────────────────────────────────────╢ ║ Computing Average Cost Single Item ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ ║ ║ Enter Item: JAR-1 ║ ║ ║ You can print the summary report for this operation out to printer: ┌────────────────────────────────────────────────────────────────────────────┐ │ Do you wish to print the summary report (COSTA2.TXT)? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ MANUALLY COMPUTE THE AVERAGE COST FOR AN ITEM This option will prompt you to enter a valid item number, the quantity of items received, and the cost for those items. The computer will then compute a new Average Cost and put the computation into the field AVGCOST, in the database INV.DBF. ╔════════════════════════════════════════════════════════════════════════════╗ ║ ▄███████░ ██████░ ▄█████▄ ████████░ ████░ ██░ ██░ ▄██████▄ ║ ║ ██░ ▀ ██▀ ▀██░ ██░ ██░ ██░ ██░ ███░ ██░ ██░ ▀ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██▄ ██░ ██░ ██░██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ████░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░██░ ██░ █▀█▄ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ▄ ██▄ ▄██░ ██ ██▀ ██░ ██░ ██░ ███░ ██░ ██░ ║ ║ ▀███████░ ██████░ ▀█████▀ ██░ ████░ ██░ ██░ ▀███████▀ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Use this routine to adjust the Average Cost for an item. ║ ║ ║ ║ Description: Sample Item Description #1 ║ ║ Current Cost: 10.00 Onhand: 345 ║ ║ Average Cost: 10.32 ║ ║ Price: 149.99 ║ ║ Retail: 199.99 ║ ║ Enter Item Number: JAR-1 ║ ║ New Average Cost: 24.56 ║ ║ Enter New Cost: 125.00 ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO Inventory, TJS LAB Page: 17 ■ POST AVERAGE COST TO COST FOR SINGLE ITEM After prompting you to enter a valid item number, the key fields for that item are displayed, and you are prompted the second time before a post of the Average Cost is made. If you respond Y (Yes) to this option, the selected item's Average Cost (AVGCOST) with be placed/moved into the Current Cost (COST). ╔════════════════════════════════════════════════════════════════════════════╗ ║ ▄███████░ ██████░ ▄█████▄ ████████░ ████░ ██░ ██░ ▄██████▄ ║ ║ ██░ ▀ ██▀ ▀██░ ██░ ██░ ██░ ██░ ███░ ██░ ██░ ▀ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██▄ ██░ ██░ ██░██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ████░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░██░ ██░ █▀█▄ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ▄ ██▄ ▄██░ ██ ██▀ ██░ ██░ ██░ ███░ ██░ ██░ ║ ║ ▀███████░ ██████░ ▀█████▀ ██░ ████░ ██░ ██░ ▀███████▀ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Use this routine to Move the Average Cost into Current Cost. ║ ║ Item: JAR-1 ║ ║ Description: Sample Item Description #1 ║ ║ Onhand: 345 ║ ║ ┌─>> Current Cost: 10.00 █▀▀█░ ▄██▄ █▀▀█░ █▀█▀█░ ║ ║ └─<< Average Cost: 24.56 █▄▄█░ █░ █░ █░ █░ ║ ║ Real Cost: 10.00 █░ █░ █░ ▀▀▀█░ █░ ║ ║ Price: 149.99 █░ ▀██▀ █▄▄█░ █░ ║ ║ Retail: 199.99 ║ ║ ║ ║ Do you wish to move the Average Cost into Current Cost? (Y/N) * ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) DAYO Inventory, TJS LAB Page: 18 ■ POST ALL POSITIVE AVERAGE COST TO CURRENT COST A response of Y (Yes) will start the process of posting (moving) all Average Cost (AVGCOST) values into the Current Cost field (COST). ╔════════════════════════════════════════════════════════════════════════════╗ ║ ▄███████░ ██████░ ▄█████▄ ████████░ ████░ ██░ ██░ ▄██████▄ ║ ║ ██░ ▀ ██▀ ▀██░ ██░ ██░ ██░ ██░ ███░ ██░ ██░ ▀ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██▄ ██░ ██░ ██░██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ████░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░██░ ██░ █▀█▄ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ▄ ██▄ ▄██░ ██ ██▀ ██░ ██░ ██░ ███░ ██░ ██░ ║ ║ ▀███████░ ██████░ ▀█████▀ ██░ ████░ ██░ ██░ ▀███████▀ ║ ║ ║ ║ █▀▀█░ ▄██▄ █▀▀█░ █▀█▀█░ ▄█▄ █░ █░ ║ ║ █▄▄█░ █░ █░ █░ █░ █░█░ █░ █░ ║ ║ █░ █░ █░ ▀▀▀█░ █░ ██▄██░ █░ █░ ║ ║ █░ ▀██▀ █▄▄█░ █░ █░ █░ ███░ ███░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ ║ ║ This routine will move/post ALL positive Average Costs (AVGCOST) to the ║ ║ Current Cost (COST). ║ ║ ║ ║ Do you wish to move the ALL Average Cost into Current Cost? (Y/N) ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) DAYO Inventory, TJS LAB Page: 19 ■ POST ALL AVERAGE COST PROGRESS GRAPH Like most of these costing routines, the progress of this routine is displayed onto the screen: ╔════════════════════════════════════════════════════════════════════════════╗ ║ ▄███████░ ██████░ ▄█████▄ ████████░ ████░ ██░ ██░ ▄██████▄ ║ ║ ██░ ▀ ██▀ ▀██░ ██░ ██░ ██░ ██░ ███░ ██░ ██░ ▀ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██▄ ██░ ██░ ██░██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ████░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░██░ ██░ █▀█▄ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ▄ ██▄ ▄██░ ██ ██▀ ██░ ██░ ██░ ███░ ██░ ██░ ║ ║ ▀███████░ ██████░ ▀█████▀ ██░ ████░ ██░ ██░ ▀███████▀ ║ ║ ║ ║ █▀▀█░ ▄██▄ █▀▀█░ █▀█▀█░ ▄█▄ █░ █░ ║ ║ █▄▄█░ █░ █░ █░ █░ █░█░ █░ █░ ║ ║ █░ █░ █░ ▀▀▀█░ █░ ██▄██░ █░ █░ ║ ║ █░ ▀██▀ █▄▄█░ █░ █░ █░ ███░ ███░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Item Description Cost Avg Cost Real Cost║ ║ JAR-23 JAR #23 3.00 27.00 3.00║ ║ JAR-34 JAR #34 4.30 4.30 4.30║ ║ JAR-34A JAR #34 ALPHA 4.55 4.55 4.55║ ║ JAR-35 JAR #35 4.05 4.05 4.05║ ║ JAR-36 JAR #36 3.04 3.04 3.04║ ║ ║ ╚══╡████████████████████████████─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼─┼──╞╝ Esc (Exit/Abort) DAYO Inventory, TJS LAB Page: 20 ■ ZERO ALL AVERAGE COSTS This routine simply replaces the Average Cost field (AVGCOST) with the value of zero. ╔════════════════════════════════════════════════════════════════════════════╗ ║ ▄███████░ ██████░ ▄█████▄ ████████░ ████░ ██░ ██░ ▄██████▄ ║ ║ ██░ ▀ ██▀ ▀██░ ██░ ██░ ██░ ██░ ███░ ██░ ██░ ▀ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██▄ ██░ ██░ ██░██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ████░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░██░ ██░ █▀█▄ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ▄ ██▄ ▄██░ ██ ██▀ ██░ ██░ ██░ ███░ ██░ ██░ ║ ║ ▀███████░ ██████░ ▀█████▀ ██░ ████░ ██░ ██░ ▀███████▀ ║ ║ ║ ║ █████░████░██▄███░ ████░ ███░ ██░ ██░ ████░ ▄███░ ████░ ████░██████░║ ║ ██░██░ ██░ ██░██░ ██░ ██░██░ ██░ ██░ ██░ ██░ ██░ ██░██░ ██░ ║ ║ ██░ ███░ ██░ ██░██░ ██░ ██░██░ ██░ ██░ ██░ ██░ ██░ ██░██░ ██░ ║ ║ ██░ ██░ ████▀ ██░ ██░ █████░ █▄▄█░ ██░▀██░██░ ██░ ██░ ███▄ ██░ ║ ║ ██░ ██░ ██░██░ ██░ ██░ ███░███░ ████░ ██░ ██░██░ ██░ ██░ ██░ ██░ ║ ║ █████░████░██░ ██░ ████░ ██░ ██░ ██░ ████░ ▀███░ ████░ ████░ ██░ ║ ║ ║ ║ This routine will ZERO ALL Average Cost (AVGCOST) fields! ║ ║ ║ ║ Do you wish to ZERO ALL the Average Cost fields? (Y/N) * ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) DAYO Inventory, TJS LAB Page: 21 ■ COMPUTE THE REAL COST FOR ALL ITEMS The selection of this routine requires a special index of the receiving database REC.DBF before it can start the computations for Real Cost. ┌──────────────────────────────────────────────────────────┐ │ Database Name: REC.DBF │ │ Index Name: COSTING.NTX │ │ Number of Records: 106 │ │ ┌──────────────────────────────────────────────────┐ │ │ │██████████████████████████████████████████ │ │ │ └──────────────────────────────────────────────────┘ │ │ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │ └──────────────────────────────────────────────────────────┘ After the index is created, the computation of the freight value (per item) is performed. The progress is displayed onto the screen. Note, this is only the 1st pass. ╟───────────────────────────────────────────────────────────────────────────╢ ║ Computing Freight Adjustment for Real Cost Pass 1 of 2 ║ ╟───────────────────────────────────────────────────────────────────────────╢ Pass 2 computed the Real Cost and places the value into the field REALCOST in the database INV.DBF. ╟───────────────────────────────────────────────────────────────────────────╢ ║ Computing Real Cost for All Items Pass 2 of 2 ║ ╟───────────────────────────────────────────────────────────────────────────╢ After this operation, you can print the summary report out to printer. ┌───────────────────────────────────────────────────────────────────────────┐ │ Do you wish to print the summary report (COSTR1.TXT)? (Y/N) │ └───────────────────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 22 ■ MANUALLY COMPUTE THE REAL COST FOR SINGLE ITEM This option lets you 'manually' compute the Real Cost for an item by prompting you for the cost, quantity and freight amount. The Real Cost field REALCOST is updated with the subsequent computation. ╔════════════════════════════════════════════════════════════════════════════╗ ║ ▄███████░ ██████░ ▄█████▄ ████████░ ████░ ██░ ██░ ▄██████▄ ║ ║ ██░ ▀ ██▀ ▀██░ ██░ ██░ ██░ ██░ ███░ ██░ ██░ ▀ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██▄ ██░ ██░ ██░██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ████░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░██░ ██░ █▀█▄ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ▄ ██▄ ▄██░ ██ ██▀ ██░ ██░ ██░ ███░ ██░ ██░ ║ ║ ▀███████░ ██████░ ▀█████▀ ██░ ████░ ██░ ██░ ▀███████▀ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ ║ ║ Use this routine to adjust the Real Cost for an Item. ║ ║ ║ ║ Enter Item Number: JAR-1 ║ ║ Description: Sample Item Description #1 ║ ║ Price: 149.99 Onhand: 345 ║ ║ Retail: 199.99 ║ ║ Current Cost: 24.56 ║ ║ Enter Amount of Freight/Adjustment: 0.00 ║ ║ Apply to Quantity: 0 ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) DAYO Inventory, TJS LAB Page: 23 ■ POST REAL COST TO COST FOR SINGLE ITEM After prompting you for a valid item number, the key information about that item is displayed and you are then prompted to continue with the post of the Real Cost into the Current Cost. A response of Y (Yes) will post/move the value in the field REALCOST into the field COST. ╔════════════════════════════════════════════════════════════════════════════╗ ║ ▄███████░ ██████░ ▄█████▄ ████████░ ████░ ██░ ██░ ▄██████▄ ║ ║ ██░ ▀ ██▀ ▀██░ ██░ ██░ ██░ ██░ ███░ ██░ ██░ ▀ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██▄ ██░ ██░ ██░██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ████░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░██░ ██░ █▀█▄ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ▄ ██▄ ▄██░ ██ ██▀ ██░ ██░ ██░ ███░ ██░ ██░ ║ ║ ▀███████░ ██████░ ▀█████▀ ██░ ████░ ██░ ██░ ▀███████▀ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Use this routine to Move the Real Cost into Current Cost. ║ ║ Item: BOX ║ ║ Description: BOX FOR THE JARS ║ ║ Onhand: 345 ║ ║ ┌─>> Current Cost: 3.40 █▀▀█░ ▄██▄ █▀▀█░ █▀█▀█░ ║ ║ └────<< Real Cost: 0.00 █▄▄█░ █░ █░ █░ █░ ║ ║ Average Cost: 0.00 █░ █░ █░ ▀▀▀█░ █░ ║ ║ Price: 4.00 █░ ▀██▀ █▄▄█░ █░ ║ ║ Retail: 4.50 ║ ║ ║ ║ Do you wish to move the Real Cost into Current Cost? (Y/N) * ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) DAYO Inventory, TJS LAB Page: 24 ■ POST ALL POSITIVE REAL COST TO CURRENT COST This routine will move all positive values found in the field REALCOST into the field COST if you respond Y (Yes). ╔════════════════════════════════════════════════════════════════════════════╗ ║ ▄███████░ ██████░ ▄█████▄ ████████░ ████░ ██░ ██░ ▄██████▄ ║ ║ ██░ ▀ ██▀ ▀██░ ██░ ██░ ██░ ██░ ███░ ██░ ██░ ▀ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██▄ ██░ ██░ ██░██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ████░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░██░ ██░ █▀█▄ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ▄ ██▄ ▄██░ ██ ██▀ ██░ ██░ ██░ ███░ ██░ ██░ ║ ║ ▀███████░ ██████░ ▀█████▀ ██░ ████░ ██░ ██░ ▀███████▀ ║ ║ ║ ║ █▀▀█░ ▄██▄ █▀▀█░ █▀█▀█░ ▄█▄ █░ █░ ║ ║ █▄▄█░ █░ █░ █░ █░ █░█░ █░ █░ ║ ║ █░ █░ █░ ▀▀▀█░ █░ ██▄██░ █░ █░ ║ ║ █░ ▀██▀ █▄▄█░ █░ █░ █░ ███░ ███░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ ║ ║ This routine will move/post ALL positive Real Costs (REALCOST) to the ║ ║ Current Cost (COST). ║ ║ ║ ║ Do you wish to move the ALL Real Cost into Current Cost? (Y/N) * ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) DAYO Inventory, TJS LAB Page: 25 ■ ZERO ALL REAL COSTS This routine will place a value of zero into the field REALCOST if you respond Y (Yes) to the prompt. ╔════════════════════════════════════════════════════════════════════════════╗ ║ ▄███████░ ██████░ ▄█████▄ ████████░ ████░ ██░ ██░ ▄██████▄ ║ ║ ██░ ▀ ██▀ ▀██░ ██░ ██░ ██░ ██░ ███░ ██░ ██░ ▀ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██▄ ██░ ██░ ██░██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ████░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░██░ ██░ █▀█▄ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ████░ ██░ ██░ ║ ║ ██░ ▄ ██▄ ▄██░ ██ ██▀ ██░ ██░ ██░ ███░ ██░ ██░ ║ ║ ▀███████░ ██████░ ▀█████▀ ██░ ████░ ██░ ██░ ▀███████▀ ║ ║ ║ ║ ████░███░█▄██░▄██▄ █▄██░███░ █░ █░ ▄██░▄██▄ ▄███░███░ ║ ║ █░█░ █░ █░█░ █░ █░ █░█░ █▀█░ █░ █░ █░ █░█░ █░ ║ ║ █░ ██░ █░ █░█░ █░ █░ █░██░ █░█░ █░ █░ █░ █░█▄ █░ ║ ║ █░ █░ ███▀ █░ █░ ███▀ █░ █████░█░ █░ █░ █░ ▀█▄ █░ ║ ║ █░ █░ █░▀█░█░ █░ █░▀█░█░ █░ █░█░ █░ █░ █░ █░ █░ ║ ║ ████░███░█░ █░▀██▀ █░ █░███░█░ █░███░ ▀██░▀██▀ ███▀ █░ ║ ║ ║ ║ This routine will ZERO ALL Real Cost (REALCOST) fields! ║ ║ ║ ║ Do you wish to ZERO ALL the Real Cost fields? (Y/N) * ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) ■ COMPUTE THE AVERAGE & REAL COST FOR ALL ITEMS This routine is the combination of 2 previous options (1 & 7). ■ COMPUTE AND POST THE AVERAGE COST FOR ALL ITEMS This routine is the combination of 2 previous options (1 & 5). ■ COMPUTE AND POST THE REAL COST FOR ALL ITEMS This routine is the combination of 2 previous options (7 & 10). DAYO Inventory, TJS LAB Page: 26 ■ RECEIVING The receiving module can only be utilized after creating purchase orders. Use this module to 'receive' your open purchase orders (POs) with the option to record serial numbers. The initial browse screen contains information about the vendor atop the screen. Half way down the screen, data about the first detail item is also displayed onto the screen. DAYO INVENTORY Version 3.0 TJS LAB RECEIVING ╔════════════════════════════════════════════════════════════════════════════╗ ║PO: 1003 VENDOR: TLJ VENDOR NAME: TJS LAB ║ ║ETA: 09/15/90 DATE: 09/14/90 Contact: Ron Davidson ║ ║TERMS: NET 30 ADDRESS: PO Box 585366 ║ ║SHIPPER: TRUCK 4409 Beaumont Drive ║ ║BY: TJ Orlando, FL 32858-5366 ║ ║OPEN STATUS: Open PRINTED: No Phone: (407) 291-3960 ║ ║CLASS: AP COMMENT: Send Soon... ║ ║SUBTOTAL: 100.00 ADJUST: 0.00 FRGT: 0.00 TAXES: 0.00║ ║1ST ITEM VENDOR ITEM DESCRIPTION ORDERED RECEIVED║ ║B-ABC XX-12345 Everest Belly Bag 5-Pocket 43 11║ ║INVENTORY ONHAND ONORDER BO SOLDPTD SOLDYTD STOCKLEVEL BIN ║ ║ 20 38 0 0 0 0 12 ║ ╟─────────────────[ RECEIVE PURCHASE ORDERS INTO INVENTORY ]─────────────────╢ ║ PO VENDOR NAME ║ ║───────────────────╥────────────╥───────────────────────────────────────────║ ║ 1000 ║ TLJ ║ TJS LAB ║ ║ 1001 ║ TLJ ║ TJS LAB ║ ║ 1002 ║ TLJ ║ TJS LAB ║ ║ 1003 ║ TLJ ║ TJS LAB ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Select) F3 (Detail) F4 (Receipts) Find F5 (PO) F6 (Vendor) F7 (Vendor Name) F8 (Control) ■ BROWSE PO DETAIL ITEMS - F3 Press F3 to browse (view only) all purchase order detail items. The lower section of the screen becomes the browse window: ╟─────────────────────────[ PURCHASE ORDER DETAIL ]──────────────────────────╢ ║ PO VENDOR ITEM DESC ║ ║───────────╥────────────╥──────────────╥────────────────────────────────────║ ║ 1003 ║ TLJ ║ B-ABC ║ EVEREST BELLY BAG 5-POCKET ║ ║ 1003 ║ TLJ ║ A-ABC ║ DENIM BELLY BAG ║ ║ 1003 ║ TLJ ║ F-ABC ║ FLORIDA NYLON 3-PKT BELLY BAG ║ ║ 1003 ║ TLJ ║ J-ABC ║ CHILDREN'S BELLY BAGS ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Find: F5 (PO) F6 (Item) F7 (Vendor) F8 (VendItem) DAYO Inventory, TJS LAB Page: 27 ■ BROWSE RECEIPTS - F4 Press F4 to browse (view only) all receipts (receivers). The lower section of the screen becomes the browse window: ╟────────────────────────────[ BROWSE RECEIPTS ]─────────────────────────────╢ ║ KEY PO VENDOR ITEM DESC ║ ║───────╥────────╥────────────╥──────────────╥───────────────────────────────║ ║ 4 ║ 1003 ║ TLJ ║ B-ABC ║ EVEREST BELLY BAG 5-POCKET ║ ║ 4 ║ 1003 ║ TLJ ║ A-ABC ║ DENIM BELLY BAG ║ ║ 4 ║ 1003 ║ TLJ ║ F-ABC ║ FLORIDA NYLON 3-PKT BELLY BAG ║ ║ 4 ║ 1003 ║ TLJ ║ J-ABC ║ CHILDREN'S BELLY BAGS ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Find: F5 (KEY) F6 (PO) F7 (ITEM) F8 (VENDITEM) ■ RECEIVE PO Press then Enter/Return key to start the process of receiving all or part of a Purchase Order (PO). The first screen in the process will be the header information and the option to change/alter/edit any of the information on it. DAYO INVENTORY Version 3.0 TJS LAB RECEIVING ╔════════════════════════════════════════════════════════════════════════════╗ ║ ║ ║ PO: 1003 CLASS: AP ║ ║ CONTROL: 1232-SAL ║ ║ VENDOR: TLJ OPEN: T ║ ║ NAME: TJS LAB PRINTED: F ║ ║ ATTN: TJ ║ ║ ADDR1: PO BOX 585366 TERMS: NET 30 ║ ║ ADDR2: 4409 BEAUMONT DRIVE SHIPPER: TRUCK ║ ║ CITY: ORLANDO ║ ║ STATE: FL ADJUST: 0.00 ║ ║ ZIP: 32858-5366 FREIGHT: 0.00 ║ ║ PHONE: (407) 291-3960 TAXES: 0.00 ║ ║ DATE: 09/14/90 SUBTOTAL: 100.00 ║ ║ ETA: 09/15/90 ║ ║ ║ ║ BY: MG ║ ║ COMMENT: ║ ║ ║ ║ ║ ║ ║ ║ Is The Purchase Order Header Correct? (Y/N) ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO Inventory, TJS LAB Page: 28 ■ RECEIVE PO DETAIL ITEM After editing the PO header information, the PO detail line items are presented to you for selection. To receive an item, just highlight it and press Enter/Return. Note, it is safe to do this since you can abort just that detail line item if you decide not to receive it... DAYO INVENTORY Version 3.0 TJS LAB RECEIVING ╔════════════════════════════════════════════════════════════════════════════╗ ║PO: 1003 VENDOR: TLJ VENDOR NAME: TJS LAB ║ ║ETA: 09/15/90 DATE: 09/14/90 Contact: Ron Davidson ║ ║TERMS: NET 30 ADDRESS: PO Box 585366 ║ ║SHIPPER: TRUCK 4409 Beaumont Drive ║ ║BY: TJ Orlando, FL 32858-5366 ║ ║OPEN STATUS: Open PRINTED: No Phone: (407) 291-3960 ║ ║CLASS: AP COMMENT: Send Soon... ║ ║SUBTOTAL: 100.00 ADJUST: 0.00 FRGT: 0.00 TAXES: 0.00║ ║1ST ITEM VENDOR ITEM DESCRIPTION ORDERED RECEIVED║ ║B-ABC XX-12345 EVEREST BELLY BAG 5-POCKET 43 11║ ║INVENTORY ONHAND ONORDER BO SOLDPTD SOLDYTD STOCKLEVEL BIN ║ ║ 20 38 0 0 0 0 12 ║ ╟─────────────────────── RECEIVE PURCHASE ORDER ITEMS ───────────────────────╢ ║Item VendItem Description Ordered Received║ ║B-ABC XX-12345 EVEREST BELLY BAG 5-POCKET 43.000 11.000║ ║D-ABC XX-12364 DENIM BELLY BAG 3.000 1.000║ ║F-ABC XX-12566 FLORIDA NYLON 3-PKT BELLY BAG 3.000 1.000║ ║J-ABC XY-00390 CHILDREN'S BELLY BAGS 34.000 7.000║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Select PO Line Item for Receiving) DAYO Inventory, TJS LAB Page: 29 ■ EDIT PO LINE ITEM DATA Key information about the selected PO detail line item is displayed onto the screen with the option to edit the vendor Item Number (VENDITEM), the description (DESC), the cost (COST), and to enter the amount of the product that is to be received (RECEIVED). The default amount for receipt will be the difference between the amount ordered and previous receipts. ┌─────────[ Edit PO Line Item ]────────────────┐ │ PO: 1003 │ │ │ │ VENDOR: TLJ │ │ ITEM: B-ABC │ │ VENDITEM: XX-12345 │ │ DESC: EVEREST BELLY BAG 5-POCKET │ │ COST: 5.00 │ │ DATE: 09/14/90 │ │ ETA: 09/15/90 │ │ LASTRECV: / / │ │ │ │ ORDERED: 43.000 │ │ │ │ RECEIVED: 11.000 │ │ │ │ Receiving Now: 32.000 │ └──────────────────────────────────────────────┘ ■ SERIAL NUMBERS If any item is declared to be 'serialized', a window will appear requesting a serial number for every item received. An item is flagged as 'serialized' by setting the field SERIALNO to .T. (True/Yes) in the inventory database (INV.DBF). ┌─────────[ Edit PO Line Item ]────────────────┐ │ PO: 70011 │ │ │ │ VENDOR: NEWVENDOR │ │ ITEM: AF31203 │ │ VENDITEM: │ │ DESC: SHELL RINGS │ │ COST: 4239.02 │ │ DATE: 11/19/90 │ │ ETA: 11/20/90 ╔═══════════════════════════════════════╗ │ LASTRECV: / / ║ This Item Requires Input of ║ │ ║ Serial Numbers ║ │ ORDERED: 34.0║ Enter Serial Number (1 of 34) ║ │ ║ XXX-123456789 ║ │ RECEIVED: 0.0╚═══════════════════════════════════════╝ │ │ │ Receiving Now: 34.00 │ └──────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 30 ■ LAST CHANCE TO ABORT RECEIVING PROCESS Everything you have done up to this point can be aborted now, or press 'C' to continue. ╔════════════════════════════════════════════════════════════════════╗ ║ ║ ║ Is everything Ok? ║ ║ ║ ║ Last Chance To Abort! ║ ║ ║ ║ Press C to continue, Esc to Abort... ║ ║ ║ ╚════════════════════════════════════════════════════════════════════╝ Databases are updated with your changes. This critical process is called 'POSTING'. NEVER INTERRUPT THIS ROUTINE AT THIS STAGE! DAYO Inventory, TJS LAB Page: 31 Many of the databases are affected by the post. The inventory database (INV.DBF), receives a new ONHAND quantity, and possibly a COST change (updated from the purchase order database). The OPEN_PURC & RECV_PURC fields (in the VENDORS.DBF) are updated with the dollars amounts of total open purchase orders and total dollar received into inventory for that vendor. The purchase order detail database (POD.DBF) is adjusted to show the amount of items received, and optionally 'closed', if they are filled (RECEIVED = ORDERED). Finally, a record is added to the receiving database (REC.DBF) for each purchase order detail line item received. Dependent on the configuration settings, the printing of receivers and/or inventory price tags will occur. The default is NOT to print either. If set to print receivers/key recs, a printout (RECEIVER) will print. Insure your printers are online and ready BEFORE starting the receiving process! ■ EXAMPLE OF A PRINTED RECEIVER ------------------ RECEIVER: 109 Date: 09/15/90 ------------------ Time: 01:30:20 Purchase Order: 1003 Vendor: TLJ PO Date: 09/14/90 Control: 2309-ABC ETA: 09/15/90 TJS LAB Shipper: TRUCK Attn: TJ Terms: NET 30 PO BOX 585366 ORLANDO, FL 32858-5366 Phone: (407) 291-3960 PO Comments: Only reds ones could be found... Item VendItem Desc Qty Cost Each ------------ ------------ ------------------------------ ------- ---------- B-ABC XX-12345 EVEREST BELLY BAG 5-POCKET 1 5.00 A-ABC XX-12364 DENIM BELLY BAG 1 6.00 Serial Number: 98324-ABC F-ABC XX-12566 FLORIDA NYLON 3-PKT BELLY BAG 1 7.00 J-ABC XY-00390 CHILDREN'S BELLY BAGS 14 8.00 ------------ ------------ ------------------------------ ------- ---------- Totals: 17 130.00 ------------------ RECEIVER: 109 ------------------ DAYO Inventory, TJS LAB Page: 32 If set to print inventory price tags, they will be automatically printed, one for each quantity received. Inventory tags contain the ITEM, VENDITEM, DESC, UNIT, and PRICE. The label prints only on the standard label size of 3.5 by 15/16 inches at 6 lines per inch (6 LPI). ■ EXAMPLE OF INVENTORY TAGS: │■│┌─────────────────────────────────────┐│■│ │■││ 123456 SDF1000-A ││■│ │■││ ││■│ │■││ RATHER LARGE RED JAR ││■│ │■││ ││■│ │■││ 299.99 ││■│ │■│└─────────────────────────────────────┘│■│ │■│┌─────────────────────────────────────┐│■│ │■││ 123090 SDF0303-09 ││■│ │■││ ││■│ │■││ GREEN BIKE TIRE ││■│ │■││ ││■│ │■││ 34.00 ││■│ │■│└─────────────────────────────────────┘│■│ │■│┌─────────────────────────────────────┐│■│ DAYO Inventory, TJS LAB Page: 33 ■ VENDORS The VENDORS module gives you the ability to browse/view/edit your vendors: DAYO INVENTORY Version 3.0 TJS LAB VENDORS ┌───[February 1991]──┐ ╔══════════════════════════════════════════════════════════════════════════════ ║ Vendor: 1234 Comment: This vendor is usually 3 weeks late ║ Name: THE RED BARREL STORE Attn: GEORGE ║ Addr1: 120 LENOIR STREET Account: 234-4 ║ Addr2: ║ City/State: POMEROY, OH ║ Zip: 12404 Telephone: (903) 345-555 101 ║ Date: 01/04/91 Type: A Class: AP ╚═════════════════════════[ VENDORS DATABASE BROWSE ]══════════════════════════ VENDOR NAME ADDR1 ────────────╥────────────────────────────────╥─────────────────────────────── 1234 ║ THE RED BARREL STORE ║ SUITE 2344 IRQ-444 ║ INTERNATIONAL IROQERS ║ PO BOX 1234 SDF ║ ONE STOP DEPARTMENT STORE ║ VEN-10 ║ ROSEMONT APARTMENTS ║ VEN-11 ║ ROSEMONT ACRES ║ VEN-12 ║ ROSEMONT MIDDLE SCHOOL ║ PO BOX 2134 VEN-13 ║ ROSEMONT SCHOOL FOR THE OLDER ║ VEN-14 ║ BULAS BAR & GRILL ║ ON THE CORNER OF 45TH AND 3RD VEN-15 ║ RELIABLE MANUFACTURER ║ PO BOX 9004 Esc (Exit) F1 (Help) F2 (Edit) F3 (List Open POs) Ctrl N (Add) Ctrl U (Delete) Ctrl F1 (Reset OPEN_PURC) Find F5 (Vendor) F6 (Vendor Name) Press F2 to edit the vendors with the FULL SCREEN EDIT: DAYO INVENTORY Version 3.0 TJS LAB VENDORS ┌───[February 1991]──┐ ┌──────────────────────[ EDIT VENDOR - FULL SCREEN EDIT ]────────────────────┐ │ VENDOR: SDF1000 │ │ NAME: THE RED BARREL STORE │ │ ADDR1: SUITE 2344 │ │ ADDR2: 2344 EASTER LANE │ │ CITY: WINTER PARK │ │ STATE: FL │ │ ZIP: 23434 │ │ PHONE: 293-234-3444 │ │ TERMS: COD │ │ SHIPPER: DELIVERY │ │ DATE: 11/26/89 │ │ LASTDATE: 12/28/89 │ │ TYPE: D43 │ │ CLASS: 34 │ │ OPEN_PURC: 816.00 │ │ RECV_PURC: 1464.00 │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO Inventory, TJS LAB Page: 34 Press F3 to list any open purchase orders (belonging to that vendor): ┌────────────────────────────────────────────────────────┐ │ PO Date Subtotal Tx/Adj/Frg Total │ │ 234 11/12/89 34.00 0.00 34.00 │ │ 236 11/15/89 1824.00 111.12 1935.12 │ │ 237 11/16/89 35.06 0.00 35.06 │ │ 245 11/18/89 829.00 0.00 829.00 │ │ 257 11/21/89 86.00 0.00 86.00 │ │ 289 11/25/89 24.00 10.56 34.56 │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────┘ Press Ctrl N to add/create a new vendor. The display window at the top left of the screen becomes a data entry window for the input of the new vendor data: ╔═[ Add New Vendor ]═════════════════════════════════════════════════════════╗ ║ Vendor: SDF1001 Comment: Best supplier of roses ║ ║ Name: FLOWERS SHOP OF WINTER PARK Attn: SALLEY ║ ║ Addr1: PO BOX 23400 Account: 000-333A ║ ║ Addr2: 1500 EAST WEST BLVD. ║ ║ City/State: WINTER PARK FL ║ ║ Zip: 23444 Telephone: 407-291-5555 ║ ║ Date: 06/15/91 Type: A Class: AP ║ ╚═════════════════════════[ VENDORS DATABASE BROWSE ]════════════════════════╝ Press F5 to find/seek a vendor based on the index of VENDOR: ┌─────────────────────────────────────────────────────────────┐ │ Enter VENDOR: SDF │ └───────────────────────────────────────────────────TJS LAB───┘ Press F6 to find/seek a vendor based on the index of vendor NAME: ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: THE RED BARREL │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO Inventory, TJS LAB Page: 35 ■ PURCHASE ORDERS Purchasing items from a vendor is generally accomplished through purchase orders. You create a 'shopping list' of items you want to buy, and send that list to the vendor selling those items. That list is called a purchase order DAYO Inventory facilitates the creation of purchase orders by presenting you with a system that allows you to 'point and select' items without having to RE-KEY in the item and vendor information. Like the INVENTORY and VENDORS modules, the PURCHASE ORDERS module centers around a browse screen of the open purchase orders. What is actually displayed are the header records for your open purchase orders (POH.DBF). Note that all fields are available for viewing and optionally editing, by scrolling up/down/left/right with the arrow keys... The top left of the purchase order browse screen is a display of the key fields of the currently highlighted purchase order header record. The lower center of the screen contains the purchase order headers records indexed by one of three indexes. DAYO INVENTORY Version 3.00 TJS LAB PURCHASE ORDERS ┌─────[June 1991]───┐ ╔════════════════════════════════════════════════════════════════════════════╗ ║ PO: 114 Open: Y ETA: 06/24/91 ║ ║ Vendor: ABC Subtotal: 1100.00 ║ ║ Name: ABC Liquors Attn: Mike Zelik ║ ║ Addr1: 100 East Lancaster Road Account: 100000 ║ ║ City/State: Orlando, FL ║ ║ Zip: 32810 Telephone: (407) 291-5555 ║ ║ Date: 06/23/91 Control: SALES-2393 Work Order: 304 ║ ║ Comment: Please send only red ones ║ ╚═════════════════════[ PURCHASE ORDERS DATABASE BROWSE ]════════════════════╝ PO VENDOR NAME ────────────────────╥────────────╥──────────────────────────────────────────── 111 ║ TLJ ║ TIM JOHNSON'S GUITARS 112 ║ TLJ ║ TIM JOHNSON'S GUITARS 113 ║ TLJ ║ TIM JOHNSON'S GUITARS 114 ║ ABC ║ ABC Liquors 115 ║ TLJ ║ TIM JOHNSON'S GUITARS 116 ║ TLJ ║ TIM JOHNSON'S GUITARS 117 ║ TLJ ║ TIM JOHNSON'S GUITARS Esc (Exit) F1 (Help) F2 (Edit) F3 (View Detail) F4 (Print PO) Ctrl N (Add) Ctrl U (Delete) Ctrl F1 (Reset Subtotal) Ctrl F2 (Vendor) Alt N (PO Notes) Find F5 (PO) F6 (Vendor Name) F7 (Vendor Code) F8 (Control) F9 (WO) <INSERT ON> <NOTES> 4/6 DAYO Inventory, TJS LAB Page: 36 Editing the entire purchase order header record on one screen is accomplished by pressing F2 while in the purchase order module. ┌──────────────────[ EDIT PURCHASE ORDER - FULL SCREEN EDIT ]────────────────┐ │ PO: 101 PRINTED: F │ │ VENDOR: SDF1234 COMMENT: Only red ones available│ │ NAME: JOE MORGAN, INC │ │ ATTN: SUE │ │ ADDR1: PO BOX 234 │ │ ADDR2: SUITE 34 │ │ CITY: WINTER PARK │ │ STATE: FL │ │ ZIP: 23455-6787 │ │ PHONE: 923-430-5555 │ │ DATE: 11/26/89 │ │ ETA: 12/21/89 │ │ SUBTOTAL: 3.00 │ │ TAXES: 0.00 │ │ ADJUST: 3453.00 │ │ FREIGHT: 0.00 │ │ TERMS: NET 10 │ │ SHIPPER: FLORIDA FREIGHT │ │ BY: SUE MORGAN │ │ OPEN: T │ │ CONTROL: 339-39DIG │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ BROWSE PURCHASE ORDER DETAIL LINE ITEMS You can view the detail purchase records by pressing the F3 key. Note that what is displayed is the purchase order detail line items (lower & center of screen). Like all the other browse screens, the other fields in the record are accessed by using the left/right/up/down arrow keys. DAYO Inventory, TJS LAB Page: 37 DAYO INVENTORY Version 3.00 TJS LAB PURCHASE ORDERS ┌─────[June 1991]────┐ ╔════════════════════════════════════════════════════════════════════════════╗ ║ PO: 100 Open: Y ETA: 06/16/91 ║ ║ Vendor: GEORGE-A Subtotal: 34.00 ║ ║ Name: GEORGE MOONILAL Attn: GEORGE M. ║ ║ Addr1: PO BOX 939 Account: ABC-001 ║ ║ City/State: SANTA SAM, FL ║ ║ Zip: 32791 Telephone: 305 393-5555 344 ║ ║ Date: 06/15/91 Control: 34000 ║ ║ Comment: ║ ╚═════════════════════[ PURCHASE ORDERS DATABASE BROWSE ]════════════════════╝ PO VENDOR ITEM DESC ────────────╥────────────╥──────────────╥──────────────────────────────────── 100 ║ SDF1020 ║ 10101 ║ LARGE AND VERY PRETTY JAR 100 ║ SDF1020 ║ 10244 ║ HILLBILLY PURTY JAR 102 ║ SDF1020 ║ 39302 ║ HILLBILLY PURTY UGLY JAR 102 ║ SDF1020 ║ 03933 ║ LARGE UGLY JAR 103 ║ SDF1030 ║ 83933 ║ DEFENDER CUP 103 ║ SDF1030 ║ 98399 ║ COP CUP 104 ║ 19239 ║ 83773 ║ A CUP 105 ║ 19293 ║ 73595 ║ CUP 106 ║ 124002 ║ 39393 ║ NEW SLAVE 106 ║ 124002 ║ 33432 ║ YELLOW ROSES OF ALABAMA Esc (Exit) F1 (Help) F2 (Edit) F3 (Add From Inventory) Ctrl N (Add) Ctrl U (Delete) While in the browse screen of the purchase order detail line items, you can edit the existing detail records while in the browse mode or by pressing F2. Note that the edit function (F2) can be turned off for this browse screen by selecting 'N' to the 'Allow Browse Edit' option in the Configuration module. Additional detail line items can be added to an existing purchase order by pressing Ctrl N, or the F3 key. Note this 'ADD' option is only valid if you have not yet mailed the purchase order. The best method of adding another item to an existing purchase order is to press the F3 key. A window will appear allowing you to select/browse through the inventory file to find the item(s) you wish to add. To add an item, press Enter/Return while the cursor/highlight is upon that item line. ┌────────[ Select an Item to be added to this Purchase Order ]─────────┐ │ ITEM VENDITEM DESC │ │──────────────────╥──────────────╥────────────────────────────────────│ │ 1104 ║ SDF1104 ║ LARGE BOTTLE SIZE: 104 │ │ 1105 ║ SDF1105 ║ LARGE BOTTLE SIZE: 105 │ │ 1106 ║ SDF1106 ║ LARGE BOTTLE SIZE: 106 │ │ 1107 ║ SDF1107 ║ LARGE BOTTLE SIZE: 107 │ │ 1108 ║ SDF1108 ║ LARGE BOTTLE SIZE: 108 │ │ 1109 ║ SDF1109 ║ LARGE BOTTLE SIZE: 109 │ │ 1011 ║ SDF1011 ║ LARGE BOTTLE SIZE: 11 │ │ 1110 ║ SDF1110 ║ LARGE BOTTLE SIZE: 110 │ └──────────────────────────────────────────────────────────────────────┘ Esc (Abort/Exit) Enter (Add Highlighted Item) F5/F6/F7/F8/F9 (Find) DAYO Inventory, TJS LAB Page: 38 You can also add an item by pressing Ctrl N. This option should only be used if the item does not exist in the inventory file... You will have to type in the information. ┌──────────────────────────────────────────────────────────┐ │ Item: NEW ITEM │ │ VendItem: SADSIGHT │ │ Description: LARGE UGLY JAR │ │ Cost: 12 │ │ Type: 2 │ │ Class: 1 │ │ Taxable: Y │ │ │ │ Enter Qty: 1 │ └──────────────────────────────────────────────────────────┘ Press Esc from the purchase order detail line item browse screen to return to the main/header record browse screen for purchase orders. ■ PRINT PURCHASE ORDER From the purchase order header record browse screen, you can press F4 to print the purchase order. Ready your printer and press Enter/Return when ready to start printing. Press Esc to abort. ┌────────────────────────────────────────────────────────────────────────────┐ │ Ready your Standard printer, then Press Enter to Start Printing... │ │ Press Esc now to abort... │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ EXAMPLE OF A PURCHASE ORDER (next page) The standard and a laser format are the only two purchase order formats available. The default is the standard format (next page). DAYO Inventory, TJS LAB Page: 39 Purchase Order: 433 Page 1 Control: 890-ABC Date of PO: 11/28/89 Date Printed: 12/04/89 00:24:16 YOUR COMPANY, INC ATTN: Purchasing/Inventory P.O. BOX 5555 ANYCITY, XX 55555-5555 800-555-5555 Serviced by: SALLY MORGAN ----------------------------------------------------------------------------- Vendor: 1 To: THE RED BARN STORE Terms: COD SUITE 2344 Shipper: DELIVERY 2344 EASTER LANE ETA: 11/29/89 WINTER PARK, FL 23434 293-234-3444 Comments: ----------------------------------------------------------------------------- ITEM DESCRIPTION QTY COST EXTENDED ------------ ------------------------------ ------- ---------- ---------- 838902 A RATHER MEDIUM SIZE JAR 10 10.00 100.00 834562 A RATHER LARGE SIZE JAR 10 10.00 100.00 833452 A RATHER SMALL SIZE JAR 10 10.00 100.00 838453 A RATHER TINY SIZE JAR 10 10.10 101.00 835402 A RATHER MICROSCOPIC JAR 10 10.00 100.00 836565 A RATHER INVISIBLE JAR 10 10.00 100.00 *** Nothing Follows *** -------------------------------------------------------------------------- Special Instructions Sales Total: 601.00 Adjustments: 0.00 Freight/Other: 30.00 Subtotal: 631.00 Tax: 0.00 Total: 631.00 ---------------------------- x DAYO Inventory, TJS LAB Page: 40 TJS LAB will customize your purchase order forms to almost any specification, or simply to print upon a pre-printed form of your choosing. See the section on contract programming/customization (near the end of this document). ■ ADD/CREATE A NEW PURCHASE ORDER Press Ctrl N at the first browse screen for purchase orders (header records). The display window at the top left of the screen will become the data entry screen for the header/vendor information: ╔═[ Add New Purchase Order ══════════════════════════════════════════════════╗ ║ Vendor: GEORGE-A ║ ║ Name: GEORGE MOONILAL ║ ║ Addr1: PO BOX 939 : GEORGE M. ║ ║ Addr2: Account: ║ ║ City/State: SANTA SAM FL ║ ║ Zip: 32791 Telephone: D ║ ║ ETA: 06/16/91 Control: D ║ ║ Comment: ║ ╚═════════════════════[ PURCHASE ORDERS DATABASE BROWSE ]════════════════════╝ Note that if the vendor code is found in the vendor database (VENDORS.DBF), the rest of the purchase order header record will be automatically entered. Otherwise you will need to enter in all of the vendors data! After the data is completed, press Enter/Return on the last field (ETA), or press PgDn/PgUp. If the vendor did not already exist in the vendor file, you will be prompted to add it: ┌────────────────────────────────────────────────────────────────────────────┐ │ Vendor: NEW VENDOR did not exist in then VENDORS.DBF! Add? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ Deleting a purchase order is accomplished by pressing Ctrl U on the highlighted purchase order. This action will delete the detail for that purchase order as well, so BE CAREFUL! ■ RESET THE PURCHASE ORDER SUBTOTAL Pressing Ctrl F1 will cause this application to 'clean out', and recalculate the SUBTOTAL field in the purchase order header record. This option is mandatory whenever you add another item to an existing purchase order! On the other hand, it should not be used if any of the product has already been received! DAYO Inventory, TJS LAB Page: 41 Viewing additional vendor information for the highlighted purchase order, can be accomplished by pressing Ctrl F2. ┌───────────────────────────────────────┐ │ Vendor: NEW VENDOR │ │ HAPPY CLOWN STORES │ │ PO BOX 234 │ │ │ │ SUMTER, DSC 234433 │ │ Date: 12/05/89 Last Used: / / │ │ Type: Class: │ └───────────────────────────────────────┘ While in the browse screen for purchase orders (header records), you can search/find a purchase order by one of three indexes, PO, NAME, and the VENDOR. Press F5, F6, or F6 to bring up a prompt asking you to enter in the PO or character string you wish to find. Note that you only need to type in the left/first characters of the NAME and VENDOR as required. The search will highlight the first record that matches the character string you entered... Example of finding/searching for a purchase order, based on the PO: ┌─────────────────────────────────────────────────────────────┐ │ Enter PO: 123 │ └───────────────────────────────────────────────────TJS LAB───┘ Example of finding/searching for a PURCHASE order, based on the vendor NAME: ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: TOM │ └───────────────────────────────────────────────────TJS LAB───┘ Example of finding a PURCHASE order, based on the VENDOR code: ┌─────────────────────────────────────────────────────────────┐ │ Enter VENDOR: SDF │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO Inventory, TJS LAB Page: 42 ■ PURCHASE ORDER NOTES (PO NOTES) Press Alt N to bring up a view/edit screen of the purchase order notes for the currently highlighted purchase order. Note, only the 1st 18 lines of the PO notes will print onto the purchase order. ╔═════════════════════[ Edit/View Purchase Order Notes ]═════════════════════╗ ║ █▄████░ ▄████▄ ██░ ██░ ▄████▄ ██████░ ████░ █████░ ║ ║ ██░ ██░ ██░ ██░ ███░██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██████░ ██░ ██░ ██████░ ██░ ██░ ██░ ███░ █████░ ║ ║ ██░ ██░ ██░ ██░███░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ▀████▀ ██░ ██░ ▀████▀ ██░ ████░ █████░ ║ ║ PO: 3 Vendor: ABC Name: ABC Liquors ║ ║ ║ ║ Put any information about the purchase order into this space. Up to 18 ║ ║lines! ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Import) *** Note, only the 1st 18 lines of these notes will print onto the PO... DAYO Inventory, TJS LAB Page: 43 ■ REPORTS DAYO Inventory comes with 19 report options. These reports are accessed in the REPORTS module (off the Main Menu): ╔══════════════════════════════════════════════════════╗ ║ DAYO INVENTORY REPORTS ║ ║ Select Printer Setup ║ ║ Option -> Inventory Adjustments Report ║ ║ Expanded Inventory Report ║ ║ Available Inventory Report ║ ║ Warehouse Report ║ ║ ReOrder Report ║ ║ Item Movement Report ║ ║ Inventory Tags/Labels ║ ║ Purchase Orders (Headers) ║ ║ Purchase Orders (Detail) ║ ║ PO Headers - Specific WO ║ ║ PO Detail - Specific WO ║ ║ Vendors Expanded Report ║ ║ Vendor Labels ║ ║ Top 10 Vendors Graph ║ ║ Item Receipts ║ ║ Configuration Status ║ ║ View Reports On Screen ║ ║ Exit ║ ╚══════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Select Report Option) Two of these reports are actually labels (Inventory Tags and Vendor Address Labels). The Graph report option is an on-screen graph of your top ten vendors. Note that you can only print this to the printer by doing a 'Print Screen'. The Database and the Config Status reports are 80 wide column reports. The remaining reports require a wide carriage printer, or small print. They range in column width from 90 to 131 characters. Most of the reports can be printed to the printer or a file. Headings can be added to the reports. These headings will default to your company name (as defined in the Configuration module). Date ranges are available on some of the reports (Adjustments, PO header, PO detail, and the Receiving reports). DAYO Inventory, TJS LAB Page: 44 ■ INVENTORY ADJUSTMENTS REPORT ┌────────────────────────────────────────────────────────┐ │ DAYO INVENTORY REPORTS │ │ This report prints out all recorded inventory │ │ adjustments for a given date range. │ │ The Report Form Name is INVADJ.FRM and reports │ │ the following fields (from the INVADJ.DBF): │ │ ITEM VENDITEM QTY │ │ COST PRICE RETAIL │ │ DOLLARS REASON DATE │ │ │ │ Enter Heading: TJS LAB │ │ │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ │ │ Enter File Name: ADJUST.TXT │ │ │ │ │ │ Start Date: 11/04/89 Ending Date: 12/04/89 │ │ │ └────────────────────────────────────────────────────────┘ ■ EXPANDED INVENTORY REPORT ┌────────────────────────────────────────────────────────┐ │ DAYO INVENTORY REPORTS │ │ The Default Expanded Inventory Report (EXPANDED.FRM) │ │ contains the following fields/variables: │ │ ITEM COST │ │ DESC RETAIL │ │ ONHAND PRICE │ │ ONORDER TYPE │ │ VENDITEM CLASS │ │ VENDOR │ │ │ │ Select the Index -> ITEM (ITEM) │ │ DESCRIPTION (DESC) │ │ VENDOR CODE (VENDOR) │ │ VENDOR ITEM (VENDITEM) │ │ TYPE (TYPE) │ │ Enter Heading: EXPANDED REPORT │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ Enter File Name: EXPANDED.TXT │ └────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 45 ■ AVAILABLE INVENTORY REPORT ┌────────────────────────────────────────────────────────┐ │ DAYO INVENTORY REPORTS │ │ The Available Report only prints items with an ONHAND │ │ not equal to zero. Otherwise the same as the Expanded. │ │ ITEM COST │ │ DESC RETAIL │ │ ONHAND PRICE │ │ ONORDER TYPE │ │ VENDITEM CLASS │ │ VENDOR │ │ │ │ Select the Index -> ITEM (ITEM) │ │ DESCRIPTION (DESC) │ │ VENDOR CODE (VENDOR) │ │ VENDOR ITEM (VENDITEM) │ │ TYPE (TYPE) │ │ Enter Heading: AVAILABLE REPORT │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ Enter File Name: AVAILABLE.TXT │ └────────────────────────────────────────────────────────┘ ■ INVENTORY WAREHOUSE REPORT ┌────────────────────────────────────────────────────────┐ │ DAYO INVENTORY REPORTS │ │ The Warehouse Report is used to report all quantities │ │ in the databases: INV.DBF & WAREHOUS.DBF │ │ │ │ The following fields/variables are contained in the │ │ Default Warehouse Report Form (WAREHOUS.FRM): │ │ ITEM LOC1 LOC5 │ │ VENDITEM LOC2 LOC6 │ │ DESC LOC3 LOC7 │ │ ONHAND LOC4 TOTAL │ │ Select the Index -> ITEM (ITEM) │ │ DESCRIPTION (DESC) │ │ VENDOR CODE (VENDOR) │ │ VENDOR ITEM (VENDITEM) │ │ TYPE (TYPE) │ │ Enter Heading: TJS LAB │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ Enter File Name: WAREHOUS.TXT │ └────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 46 ■ INVENTORY REORDER REPORT ┌────────────────────────────────────────────────────────┐ │ DAYO INVENTORY REPORTS │ │ The ReOrder Report is used to alert you to shortages │ │ in the inventory database (INV.DBF). │ │ This report can be used as an Excess Report. │ │ The following fields/variables are contained in the │ │ ReOrder Report Form (REORDER.FRM): │ │ ITEM ONORDER EXTENDED COST │ │ VENDITEM STOCKLEVEL │ │ DESC REORDER │ │ ONHAND COST │ │ Select the Index -> ITEM (ITEM) │ │ DESCRIPTION (DESC) │ │ VENDOR CODE (VENDOR) │ │ VENDOR ITEM (VENDITEM) │ │ TYPE (TYPE) │ │ Enter Heading: TJS LAB │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ Enter File Name: REORDER.TXT │ │ Include Negative ReOrder Quantities? (Y/N) │ └────────────────────────────────────────────────────────┘ ■ INVENTORY MOVEMENT REPORT ┌────────────────────────────────────────────────────────┐ │ DAYO INVENTORY REPORTS │ │ The Movement Report tells you what items are selling/ │ │ moving in the inventory database (INV.DBF). │ │ Requires input of all sales (for each Item), into the │ │ SOLDPTD field, or the use of DAYO_POS. │ │ The following fields/variables are contained in the │ │ Movement Report Form (MOVEMENT.FRM): │ │ ITEM COST SOLDPTD │ │ VENDITEM PRICE SOLDYTD │ │ DESC ONHAND │ │ VENDOR ONORDER │ │ Select the Index -> ITEM (ITEM) │ │ DESCRIPTION (DESC) │ │ VENDOR CODE (VENDOR) │ │ VENDOR ITEM (VENDITEM) │ │ TYPE (TYPE) │ │ Enter Heading: TJS LAB │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ Enter File Name: MOVEMENT.TXT │ │ Include Zero SOLDPTD Items? (Y/N) │ └────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 47 ■ VALUATION EXPANDED REPORT The Valuation Expanded Report is essentially the same as the Inventory Expanded report except that the Valuation is included. A dBase (tm) compatible report form is required (VALUATIO.FRM). The following fields/variables are included on this report: ITEM ONORDER TYPE VENDOR ITEM COST CLASS DESCRIPTION RETAIL ONHAND EXTENDED COST EXTENDED PRICE EXTENDED RETAIL PRICE PROFIT RETAIL PROFIT The first prompt is to select the index (order of the report): ╔══════════════════════════════════════════════════════╗ ║The Default Valuation Inventory Report (VALUATIO.FRM) ║ ║contains the following fields/variables: ║ ║ ITEM COST ║ ║ DESC RETAIL ║ ║ ONHAND PRICE ║ ║ ONORDER TYPE ║ ║ VENDITEM CLASS ║ ║ VALUATION ║ ║ ║ ║Select the Index -> ITEM (ITEM) ║ ║ DESCRIPTION (DESC) ║ ║ VENDOR CODE (VENDOR) ║ ║ VENDOR ITEM (VENDITEM) ║ ║ TYPE (TYPE) ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚══════════════════════════════════════════════════════╝ DAYO Inventory, TJS LAB Page: 48 The second prompt is for a 'filter' or condition. The filter must/can be any valid dBase (tm) expression. To include all records (no filter), just press enter on an empty (blank) prompt... ╔══════════════════════════════════════════════════════╗ ║The Default Valuation Inventory Report (VALUATIO.FRM) ║ ║contains the following fields/variables: ║ ║ ITEM COST ║ ║ DESC RETAIL ║ ║ ONHAND PRICE ║ ║ ONORDER TYPE ║ ║ VENDITEM CLASS ║ ║ VALUATION ║ ║ ║ ║Select the Index -> ITEM (ITEM) ║ ║ ║ ║Enter Filter: PRICE>100.00 ║ ║EG: TYPE = "XXX" ║ ║ ║ ║Enter Heading: TJS LAB ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║Enter File Name: VALUE.TXT ║ ║ ║ ╚══════════════════════════════════════════════════════╝ DAYO Inventory, TJS LAB Page: 49 ■ INVENTORY TAGS ┌────────────────────────────────────────────────────────┐ │ DAYO INVENTORY REPORTS │ │ The TAGS Report Option is actually a method of printing│ │ inventory tags/labels/price tags. │ │ The Inventory Tag is the standard size of 3.5x15/16, │ │ 10 Pitch, 6LPI, and contains the following fields: │ │ ITEM VENDITEM DESC PRICE │ │ │ │ ┌──────────────────────────────┐ │ │ │1002 SDF1002 │ │ │ │ │ │ │ │LARGE BOTTLE SIZE: 2 │ │ │ │ │ │ │ │ 492.50 │ │ │ └──────────────────────────────┘ │ │ ITEM │ │ Select Item -> 1002 │ │ 1003 │ │ 1004 │ │ 1005 │ └────────────────────────────────────────────────────────┘ Esc (Exit) Enter/Return (Print) F5/F6/F7/F8 (Find) ■ PURCHASE ORDER HEADER REPORT ┌────────────────────────────────────────────────────────┐ │ DAYO INVENTORY REPORTS │ │ The Purchase Order (PO) Header Report lists all Open │ │ and/or Closed POH.DBF records. │ │ │ │ The name of the PO Header Report Form is POH.FRM. │ │ │ │ Select the Index -> PURCHASE ORDER (PO) │ │ VENDOR NAME (NAME) │ │ VENDOR CODE (VENDOR) │ │ │ │ Enter Heading: TJS LAB │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ Enter File Name: POHEADER.TXT │ │ Select the Option ->Open POs │ │ Closed POs │ │ All POs │ │ Start Date: 12/05/84 Ending Date: 12/04/89 │ └────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 50 ■ PURCHASE ORDER DETAIL REPORT ┌────────────────────────────────────────────────────────┐ │ DAYO INVENTORY REPORTS │ │ The Purchase Order (PO) Detail Report lists all Open │ │ and/or Closed POD.DBF records. │ │ │ │ The name of the PO Detail Report Form is POD.FRM. │ │ │ │ Select the Index -> PURCHASE ORDER (PO) │ │ ITEM (ITEM) │ │ VENDOR CODE (VENDOR) │ │ VENDOR ITEM (VENDITEM) │ │ Enter Heading: TJS LAB │ │ │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ │ │ Enter File Name: PODETAIL.TXT │ │ │ │ Select the Option ->Open POs (Received <> Ordered) │ │ Closed POs (Received = Ordered) │ │ All POs │ │ Start Date: 12/05/84 Ending Date: 12/04/89 │ └────────────────────────────────────────────────────────┘ ■ PURCHASE ORDER HEADER REPORT - SPECIFIC WORK ORDER ╔════════════════════════════════════════════════════════╗ ║ DAYO INVENTORY REPORTS ║ ║ This Purchase Order (PO) Header Report lists all Open ║ ║ and/or Closed POH.DBF records for a specific Work ║ ║ ║ ║ Order. The name of the Report Form is POHWO.FRM. ║ ║ ║ ║ Select the Index -> PURCHASE ORDER (PO) ║ ║ ║ ║ Enter Specific Work Order Number: 1 ║ ║ ║ ║ Enter Heading: YOUR COMPANY, INC ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: POHEADER.TXT ║ ║ ║ ║ Select the Option ->Open POs ║ ║ Closed POs ║ ║ All POs ║ ║ Start Date: 06/26/86 Ending Date: 06/25/91 ║ ╚════════════════════════════════════════════════════════╝ DAYO Inventory, TJS LAB Page: 51 ■ PURCHASE ORDER DETAIL REPORT - SPECIFIC WORK ORDER ╔════════════════════════════════════════════════════════╗ ║ DAYO INVENTORY REPORTS ║ ║ This Purchase Order (PO) Detail Report lists all Open ║ ║ and/or Closed POD.DBF records for a specific Work ║ ║ ║ ║ Order. The name of the Report Form is PODWO.FRM. ║ ║ ║ ║ Select the Index -> PURCHASE ORDER (PO) ║ ║ ║ ║ Enter Specific Work Order Number: 2 ║ ║ ║ ║ ║ ║ ║ Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║ Enter File Name: PODETAIL.TXT ║ ║ ║ ║ Select the Option ->Open POs (Received <> Ordered) ║ ║ Closed POs (Received = Ordered) ║ ║ All POs ║ ║ Start Date: 06/26/86 Ending Date: 06/25/91 ║ ╚════════════════════════════════════════════════════════╝ ■ VENDORS REPORT ┌────────────────────────────────────────────────────────┐ │ DAYO INVENTORY REPORTS │ │ The Vendors Report is a printout of your Vendors.dbf. │ │ │ │ The name of the Vendors Report Form is VENDORS.FRM. │ │ │ │ │ │ Select the Index -> VENDOR CODE (VENDOR) │ │ VENDOR NAME (NAME) │ │ │ │ │ │ Enter Heading: TJS LAB │ │ │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ │ │ Enter File Name: VENDORS.TXT │ │ │ └────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 52 ■ VENDORS ADDRESS LABELS ┌────────────────────────────────────────────────────────┐ │ DAYO INVENTORY REPORTS │ │ Use this option to print Vendor address labels out. │ │ │ │ The Address Label is the standard size of 3.5x15/16, │ │ 10 Pitch, 6LPI, and contains the following fields: │ │ NAME ADDR1 ADDR2 CITY STATE ZIP │ │ │ │ ┌──────────────────────────────┐ │ │ │INTERNATIONAL IROQERS │ │ │ │PO BOX 1234 │ │ │ │4409 LINCOLN HEIGHTS │ │ │ │POMEROY, OH │ │ │ │38303 │ │ │ └──────────────────────────────┘ │ │ │ │ VENDOR │ │ Select Vendor -> IRQ-444 │ │ SDF │ │ SDF1000 │ │ VEN-10 │ └────────────────────────────────────────────────────────┘ Esc (Exit) Enter/Return (Print) F5/F6 (Find) DAYO Inventory, TJS LAB Page: 53 ■ GRAPH - TOP 10 VENDORS This graph is drawn upon the screen after summing up two fields in the vendors database (VENDORS.DBF). The fields are OPEN_PURC and the RECV_PURC. The DAYO automatically adjusts these fields when creating purchase orders, and receiving items into inventory. If you use DAYO Inventory as it was designed, this graph will be accurate... The first screen displays the progress of the summing of the two key fields. The duration of this process is dependent on the number of vendors you have, and the type of CPU you possess. Date: 12/04/89 ╔═════════════════════[ TOP 10 VENDORS GRAPH - TJS LAB ]═════════════════════╗ ║ % ║ ║ The Top 10 Vendors Report is a graph of the 10 Vendors that ║ ║ you have purchased from the most. ║ ║ ║ ║ Standby While I Compute the Statistics... ║ ║ ║ ║ Total Received: 15546.00 Total Open (Not Received): 352.00 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║▓ $ ║ ║░ $ ║ ╚══════[ ██ -> Total ▓▓ -> Total Receipts ░░ -> Amount of Open POs ]═════╝ [ % Depicts the total of RECEIPTS + OPEN POs for that Vendor ] DAYO Inventory, TJS LAB Page: 54 The screen 'paints' the finished graph onto the screen along with a message at the bottom of the screen (to exit). Wait a few seconds and the message will be replaced with the rest of the graph's legend. At this point, a print out can be produced by doing a 'Print Screen'. Date: 12/04/89 █ 68015.80 ▒ 37348.00 ░ 30667.80 ╔═════════════════════[ TOP 10 VENDORS GRAPH - TJS LAB ]═════════════════════╗ ║ % 14.4 9.0 10.0 10.7 4.7 8.5 3.5 1.0 8.1 6.3 ║ ║ ██ ║ ║ ██▒▒ ║ ║ ██▒▒ ║ ║ ██▒▒ ║ ║ ██▒▒ ║ ║ ██▒▒ ██ ║ ║ ██▒▒ ██ ██ ║ ║ ██▒▒ ██▒▒ ██▒▒ ██ ██ ║ ║ ██▒▒ ██▒▒ ██▒▒ ██ ██ ██ ║ ║ ██▒▒ ██▒▒ ██▒▒ ██ ██ ██ ░░ ║ ║ ██▒▒ ██▒▒ ██▒▒ ██ ██ ██ ░░ ██ ║ ║ ██V▒ ██▒▒ ██▒▒ ██▒▒░░ V ██ ██V ░░ ██ ║ ║ ██V▒ ██V▒ ██V▒ ██▒▒░░ ██V ██V ░░ V ██V ░░ ██V ░░ ║ ║ ██E▒ ██V▒ ██V▒ ██▒▒░░ ██E▒ ██V▒░░ ██V▒ ██E ░░ ██V ░░ ║ ║ ██N▒ ██E▒ ██E▒ ██S▒░░ ██N▒ ██E▒░░ ██E▒ ██N ░░ ██E ░░ ║ ║ ██-▒ ██N▒ ██N▒ ██S▒░░ ██-▒ ██N▒░░ ██N▒ ▒▒ ██- ░░ ██N ░░ ║ ║ ██1▒ ██-▒ ██-▒░░ ██D▒░░ ██1▒░░ ██-▒░░ ██-▒ ██1▒ ██1▒░░ ██-▒░░ ║ ║ ██7▒░░ ██8▒░░ ██9▒░░ ██F▒░░ ██5▒░░ ██4▒░░ ██5▒░░ ██1▒░░ ██4▒░░ ██7▒░░ ║ ║▓ $ 10K 6K 6K 3K 2K 2K 2K 1K 865 856 ║ ║░ $ 96 256 930 4K 777 3K 14 -1K 5K 3K ║ ╚══════[ ██ -> Total ▓▓ -> Total Receipts ░░ -> Amount of Open POs ]═════╝ [ % Depicts the total of RECEIPTS + OPEN POs for that Vendor ] DAYO Inventory, TJS LAB Page: 55 ■ RECEIVING REPORT ┌────────────────────────────────────────────────────────┐ │ DAYO INVENTORY REPORTS │ │ The Receiving Report is a printout of your Receivers; │ │ all receipts of your Items. │ │ │ │ The name of the Receiving Report Form is REC.FRM. │ │ │ │ Select the Index -> RECEIVER (KEY │ │ PURCHASE ORDER (PO) │ │ ITEM (ITEM) │ │ VENDOR ITEM (VENDITEM) │ │ Enter Heading: TJS LAB │ │ │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ │ │ Enter File Name: REC.TXT │ │ │ │ │ │ Start Date: 12/05/84 Ending Date: 12/04/89 │ │ │ │ │ └────────────────────────────────────────────────────────┘ ■ DAYO DATABASE SUMMARY REPORT ┌────────────────────────────────────────────────────────┐ │ DAYO INVENTORY REPORTS │ │ The Database Summary Report lists the DAYO INVENTORY │ │ databases with their current fields, sizes and number │ │ of records. Index files included. Not a Report Form. │ │ │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ Enter File Name: DATABASE.TXT │ │ │ │ │ └────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 56 ■ DAYO CONFIGURATION SETTINGS REPORT ┌────────────────────────────────────────────────────────┐ │ DAYO INVENTORY REPORTS │ │ The Configuration Status Settings Report lists all of │ │ configuration settings (found in file DAYOINV.CFG). │ │ This is Not a Report Form. │ │ │ │ Send Output to Printer? (Y/N) ( No -> To File) │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ Enter File Name: CONFIG.TXT │ │ │ │ │ └────────────────────────────────────────────────────────┘ **** Note that other reports can be created using dBase III+/IV as well as other compatible report writers. The MISC routines even has the LIST function for the creation of simple lists/reports... DAYO Inventory, TJS LAB Page: 57 ■ PRINTER DRIVER (SETUP) This routine was added to preclude you from having to get out of your seat to change the printer settings. The most important printer selections (ie: font size, lines per inch, orientation, ...) are made easy to evoke. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ║ ║ ║ Select Option -> Eject ║ ║ Line feed ║ ║ Normal Size ║ ║ Use this routine to set your Small/Condensed ║ ║ printer up with one or more Bold On ║ ║ of the setup strings and Bold Off ║ ║ commands listed to the right. 6 Lines per Inch ║ ║ 8 Lines per Inch ║ ║ Select the 'Change Printer Print Landscape (Laser Only) ║ ║ Default' option to change Print Portrait (Laser Only) ║ ║ printer types. Reset Printer ║ ║ Current printer is set to: Print Special String 1 ║ ║ Okidata Print Special String 2 ║ ║ Print Special String 3 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ PRINTER DRIVER OPTIONS There are 18 printer driver options to select from. The last option is to set the default printer, and the next to last is a 'SHELL' function that runs a DOS command or program. The remainder are strings/codes that are sent to the printer. Eject Print Portrait (Laser Only) Line feed Reset Printer Normal Size Print Special String 1 Small/Condensed Print Special String 2 Bold On Print Special String 3 Bold Off Print Special String 4 6 Lines per Inch Print Special String 5 8 Lines per Inch Run DOS Command/Program Print Landscape (Laser Only) Change Default Printer DAYO Inventory, TJS LAB Page: 58 ■ CHANGE DEFAULT PRINTER The last option is to change/set the default printer. This printer driver routine comes with 4 default printer types, Epson, HP Laser, Star, and Okidata. You can add (Ctrl N) as many as you want. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Current Default Printer is set to: Okidata ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ NAME LINEFEED ║ ║─────────────────────────────────────╥──────────────────────────────────────║ ║ Epson & Compatibles ║ CHR(10) ║ ║ HP Laser & Compatibles ║ CHR(10) ║ ║ Star Micro Gemini ║ CHR(10) ║ ║ Okidata ║ CHR(10) ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add) 1/4 DAYO Inventory, TJS LAB Page: 59 ■ FULL SCREEN EDIT - F2 When entering the printer codes, the string must be in the valid format or it will not be printed later when requested... ┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐ │ NAME: Epson & Compatibles │ │ LINEFEED: CHR(10) │ │ NORMAL: CHR(27)+CHR(18) │ │ SMALL: CHR(27)+CHR(15) │ │ BOLDON: CHR(27)+CHR(69) │ │ BOLDOFF: CHR(27)+CHR(70) │ │ _6LPI: CHR(27)+CHR(50) │ │ _8LPI: CHR(27)+CHR(48) │ │ PORTRAIT: │ │ LANDSCAPE: │ │ RESET: CHR(27)+CHR(64) │ │ SPEC_STR1: │ │ SPEC_STR2: │ │ SPEC_STR3: │ │ SPEC_STR4: │ │ SPEC_STR5: │ │ RUN_CMD: │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ PRINTER DRIVER DATABASE FIELD DEFINITIONS NAME - Name of printer. Type in anything you wish here LINEFEED - Code to advance printer one line NORMAL - Normal font/character size SMALL - Small font/character size BOLDON - Bold/Emphasized BOLDOFF - Bold/Emphasized off _6LPI - Code to set printer to print 6 lines per inch _8LPI - Code to set printer to print 8 lines per inch PORTRAIT - Code to set laser printer to print upright (normal) LANDSCAPE - Code to set laser printer to print sideways RESET - Reset printer code SPEC_STR1 - Any special printer string, ie: print double, skip perforation, SPEC_STR2 - print very tiny, ... SPEC_STR3 - " SPEC_STR4 - " SPEC_STR5 - " RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ... DAYO Inventory, TJS LAB Page: 60 ■ VIEW REPORTS ON SCREEN This routine was provided to aid the 'fight to stop the cutting down of trees in the world' by offering you the option to view your reports on your screen. The only limitation is on the size of the report. No reports can be viewed if they are over 32,000 bytes. (Just kidding about those trees...) Due to compiler problems (handling of memory), this routine tends to 'hang' your computer. It is not recommended you use this option if your machine is performing multitasking programs. At the first prompt, type and enter the name of the report you wish to view. ╔═════════════════════════▌ View Reports Onscreen ▐══════════════════════════╗ ║██ ██░ ████░ ████░ ██░ ██░ ██▄██░ █████░ ██▄██░ ▄███▄ ██▄██░ ██████║ ║ ██ ██░ ██░ ██░ ██░ █░ ██░ ██░██░ ██░ ██░██░ ██░██░ ██░██░ ██░ ║ ║ ██ ██░ ██░ ███░ ██░███░██░ █████░ ████░ █████░ ██░██░ █████░ ██░ ║ ║ ████░ ██░ ██░ ███░███░ ██▀█░ ██░ ██░ ██░██░ ██▀█░ ██░ ║ ║ ██░ ████░ ████░ ██░██░ ██░██░ █████░ ██░ ▀███▀ ██░██░ ██░ ║ ║ ║ ║ Use this option to view (and optionally print) any report written to disk. ║ ║ Press Enter/Return on an empty prompt to display all files with the ║ ║ extension of '.TXT'. ║ ║ No limit on file size, but a large file/report takes longer to 'load'... ║ ║ ║ ║ Enter Report File Name to View On Screen: ║ ╚════════════════════════════════════════════════════════════════════════════╝ If the file does not exist, or you press enter on an empty prompt, a window will appear showing all reports in the current directory. It is assumed that all reports will have the extension of '.TXT', which is the DAYO standard. All reports are displayed in the window, even if they are too large... ╔═══════════════════════════════════════╗ ║ File Name Size Date Used ║ ╟──────────────┬────────────┬───────────╢ ║DAYOERR.TXT │ 1090 │ 06/15/90 ║ ║BALANCE.TXT │ 3555 │ 06/15/90 ║ ║GL900615.TXT │ 79 │ 06/15/90 ║ ║CONFIG.TXT │ 1209 │ 06/15/90 ║ ║BUDGETSC.TXT │ 4129 │ 06/15/90 ║ ║CLASSRPT.TXT │ 1058 │ 06/02/90 ║ ║COA.TXT │ 1158 │ 06/02/90 ║ ┌────────────────────────┐ ║GL900602.TXT │ 1759 │ 06/02/90 ║ │ Highlight the Report │ ║PERIODS.TXT │ 968 │ 06/15/90 ║ │ using the Up or Down │ ║TRANS3.TXT │ 659 │ 06/02/90 ║ │ arrow keys, then press │ ║TRIAL.TXT │ 6712 │ 06/15/90 ║ │ Enter/Return. │ ║INC_EXP.TXT │ 3291 │ 06/15/90 ║ └────────────────────────┘ ║TRANS1.TXT │ 659 │ 06/15/90 ║ ║ASSETS.TXT │ 1300 │ 06/15/90 ║ ║LIABIL.TXT │ 1987 │ 06/15/90 ║ ║EQUITY.TXT │ 714 │ 06/15/90 ║ ╚══════════════╧════════════╧═══════════╝ DAYO Inventory, TJS LAB Page: 61 ■ REPORT VIEWING SCREEN The report viewing screen uses the complete screen. The top line displays the report name. The bottom lines show you the function keys, all 2 of them. Also displayed at the bottom of the screen is the current row/column of the cursor position. DAYOINV View Reports │ File Name: COA.TXT Page No. 1 07/27/90 INVENTORY ITEM LISTING Vendor or Item Mfg Item Description ------------ ------------ ------------------------------ 2" GUTTER 2" GUTTER SYSTEM _____________ 2ALM518 2" ALMOND COIL _____________ 2ALM519 2" ALMOND COIL _____________ 2ALM527 2" ALMOND COIL _____________ 2ALM533 2" ALMOND COIL _____________ 2ANT123 2" ANT IVORY COIL _____________ Esc (Exit) F1 (Help) DAYO Inventory, TJS LAB Page: 62 ■ CONFIGURATION The configurations settings (20+), are all accessed from within the CONFIGURATION menu (option 6 from the main menu). DAYO INVENTORY Version 3.0 TJS LAB CONFIG ┌───[February 1991]──┐ ╔════════════════════════╗ │S M T W T F S │ ║ CONFIGURATION ║ ├────────────────────┤ ╟────────────────────────╢ ████▄ ▄█▄ █░ █░ ▄██▄ │ 1 2 3 4 5 6 7│ ║Company Name ║ █░ █░ █░█░ █░ █░ █░ █░ │ 8 9 10 11 12 13 14│ ║Address ║ █░ █░ █░█░ ▀█░██ █░ █░ │15 16 17 18 19 20 21│ ║Telephone ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │22 23 24 25 26 27 28│ ║Standard Sales Tax ║ █░ █░ █░ █░ █░ █░ █░ │29 30 │ ║Last Purchase Order # ║ ████▀ █░ █░ █░ ▀██▀ │ │ ║Print Receivers ║ └────────────────────┘ ║Last Receiver Number ║ ╓────────────────────────────────────────────────╖ ║Print Inventory Tags ║ ║ DAYO INVENTORY STATISTICS ║ ║Report Printer Type ║ ╟────────────────────────────────────────────────╢ ║Report Printer Port ║ ║ DATABASE NAME RECORDS SIZE ║ ║PO Printer Type ║ ╟────────────────────────────────────────────────╢ ║PO Printer Port ║ ║ INV.DBF Inventory 4 1K ║ ║Receiver Printer Port ║ ║ POH.DBF PO Header 22 9K ║ ║Inventory Tags Port ║ ║ POD.DBF PO Detail 38 5K ║ ║Auto Daily Indexing ║ ║ VENDORS.DBF Vendors 14 7K ║ ║Visual Indexing ║ ║ REC.DBF Receiving 106 14K ║ ║Allow Browse Editing ║ ║ INVADJ.DBF Adjustments 11 2K ║ ║Color ║ ║ WAREHOUS.DBF Warehouse Qty 3 1K ║ ╟────────────────────────╢ ║ WARENAME.DBF Warehouse Names 7 1K ║ ║ Select Option ║ ╚════════════════════════════════════════════════╝ ╚════════════════════════╝ ■ CONFIGURATION LISTING Company Name PO Printer Port Address Receiver Printer Port Telephone Inventory Tags Port Standard Sales Tax Post Receiver Cost Last Purchase Order # Auto Daily Indexing Print Receivers Visual Indexing Last Receiver Number Allow Browse Editing Print Inventory Tags Display Warehouses Report Printer Type Current Directory Report Printer Port Color PO Printer Type High Intensity Close & Delete POs Print Venditem on PO Real Cost Factor Automatic GL Posting GL Database Location DAYO Inventory, TJS LAB Page: 63 ■ COMPANY NAME Enter your company name, address, and telephone number as you want it printed onto the reports and purchase orders. ┌──────────────────────────────[ COMPANY NAME ]──────────────────────────────┐ │ Enter Your Company Name: TJS LAB │ └────────────────────────────────────────────────────────────────────────────┘ ■ COMPANY ADDRESS ┌────────────────────────────[ COMPANY ADDRESS ]─────────────────────────────┐ │ Address Line 1: Attn: Purchasing/Inventory │ │ Address Line 2: P.O. BOX 555555 │ │ City, State ZIP: ANYCITY, XX 32858-5366 │ └────────────────────────────────────────────────────────────────────────────┘ ■ COMPANY TELEPHONE ┌───────────────────────────[ COMPANY TELEPHONE ]────────────────────────────┐ │ Enter Your Company Telephone: 800-555-5555 │ └────────────────────────────────────────────────────────────────────────────┘ ■ STANDARD SALES TAX The sales tax (if not zero) is used in the computation of taxes when creating purchase orders. The default is 6% (as in most of Florida). ┌───────────────────────────[ STANDARD SALES TAX ]───────────────────────────┐ │ Enter Standard Sales Tax Rate (ie: .060): .060 │ └────────────────────────────────────────────────────────────────────────────┘ ■ LAST PURCHASE ORDER NUMBER The Last Purchase Order Number is the last PO that has been printed. If this is the initial startup, the next purchase order will be '1' (the default). ┌───────────────────────[ LAST PURCHASE ORDER NUMBER ]───────────────────────┐ │ The next Purchase Order will have the value of the following, plus 1. │ │ │ │ Enter Last Purchase Order Number: 0 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 64 ■ PRINT RECEIVERS/KEY RECS Select 'Y' at the prompt for Print Key Recs/Receivers if you decide to print a record of receiving items/purchase orders. If set to 'Y', Receivers will be automatically printed on receiving items into inventory via the DAYO Receiving Module. ┌────────────────────────[ PRINT RECEIVERS/KEY RECS ]────────────────────────┐ │ If you desire to print a report for everything you receive into your │ │ inventory at the time of receipt, then select Y (YES). Note, you may │ │ have limited printer resources, and may wish to print tags instead... │ │ │ │ Do you wish to print Receivers? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ LAST RECEIVER NUMBER The Last Key/Receiver Number is initially set at '0' (the 1st Receiver will be numbered at '1'). ┌──────────────────────────[ LAST RECEIVER NUMBER ]──────────────────────────┐ │ The next Receiver Number will have the value of the following, plus 1. │ │ │ │ Enter Last Receiver Number: 0 │ └────────────────────────────────────────────────────────────────────────────┘ ■ PRINT INVENTORY TAGS Select 'Y' if you want to print Inventory Tags/price labels out at receiving time. ┌──────────────────────────[ PRINT INVENTORY TAGS ]──────────────────────────┐ │ If you desire to print a inventory tags/labels for everything you │ │ receive into your inventory at the time of receipt, then select Y. │ │ Note, you may have limited printer resources, and may wish to print │ │ Receivers/Key Recs instead. │ │ │ │ Do you wish to print Inventory Tags? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 65 ■ REPORT PRINTER TYPE The Report Printer Type is the type of printer that prints your routine reports and labels. DAYO Inventory support 2 types, Epson (tm) and Hewlett Packard LaserJet (tm). Labels can print onto the HP Laser, but were designed to be printed onto an Epson compatible, tractor printer. Most of the reports are simple (use a dBase (tm) compatible Report Form), and will work with most printers. The real benefit of the HP Laser is in the printing of purchase orders. The Laser Purchase Order is much prettier... ┌──────────────────────────[ REPORT PRINTER TYPE ]───────────────────────────┐ │ Routine reports are printed according to this selection. │ │ The STANDARD printer type is a Epson/IBM Proprinter compatible printer. │ │ The LASER printer type is a Hewlett Packard Laser compatible printer. │ │ Special Laser codes are sent to the LASER option. │ │ │ │ Enter Your Report Printer Type -> STANDARD │ │ LASER │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER PORT The Report Printer Port is by default number '1' -> LPT1. If you have, or should get another parallel printer port, you will be able to print (for example), reports on one printer, purchase orders on another. If you have a multiuser system/Network (ie: Novell), those systems can create and take care of printing to multiple printers. ┌──────────────────────────[ REPORT PRINTER PORT ]───────────────────────────┐ │ Enter Your Report Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ PURCHASE ORDER PRINTER TYPE If you have an Hewlett Packard Laser printer, select the 'HP' type for the Purchase Orders. The laser purchase order will be a custom form... The 'ST' type purchase order is the standard, and requires 8.5 x 11 inch paper, with the printer set to print at 10 pitch (standard size characters), and with a spacing of 6 line per inch (6 LPI). ┌──────────────────────[ PURCHASE ORDER PRINTER TYPE ]───────────────────────┐ │ Purchase Orders are printed according to this selection. │ │ The STANDARD PO printer type is a Epson/IBM Proprinter compatible. │ │ The LASER printer type is a Hewlett Packard Laser compatible. │ │ Special Laser codes are sent to the LASER option. │ │ │ │ Enter Your PO Report Printer Type -> STANDARD │ │ LASER │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 66 ■ PURCHASE ORDER PRINTER PORT Select the printer port that your purchase orders will be printing from. The default is 1, LPT1. ┌──────────────────────[ PURCHASE ORDER PRINTER PORT ]───────────────────────┐ │ Enter Your PO Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ RECEIVER PRINTER PORT The Key/Receiver Printer Port defaults to '1', LPT1, but can be changed. Be sure that this port does not conflict with the Inventory Tags Port... ┌─────────────────────────[ RECEIVER PRINTER PORT ]──────────────────────────┐ │ Enter Your Receiver Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ INVENTORY TAGS/LABELS PRINTER PORT Inventory Tags Port is by default set to '1', but will not print if the port is the same as the Receiver port. The idea solution would be to print receivers out on one printer/port, and tags out on another. ┌───────────────────[ INVENTORY TAGS/LABELS PRINTER PORT ]───────────────────┐ │ Enter Your Inventory Tags Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ POST RECEIVER COST TO THE INVENTORY This optional setting can be a means of automatically updating your inventory COST value. ┌────────────────────[ POST RECEIVER COST TO INVENTORY ]─────────────────────┐ │ If this option is set to Y (YES), all costs of items received will be │ │ posted to the DAYO Inventory (INV.DBF) into the COST field. This routine │ │ can provide an alternative method of updating the cost of goods in your │ │ Inventory... │ │ Averages the Cost with receipt quantities using the following algorithm: │ │ ((COST*ONHAND)+(NEWCOST*RECEIVED))/(ONHAND+RECEIVED) │ │ │ │ Post Receiver Cost To Inventory? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 67 ■ APPLY A REAL COST FACTOR TO RECEIPTS OF ITEMS ┌─────────────[ APPLY A REAL COST FACTOR TO RECEIPTS OF ITEMS ]──────────────┐ │ If you wish to apply a real cost factor (increase the cost) to items │ │ at time of receipt, then enter a value here. │ │ This value may be determined by the sum of the freight divided by the │ │ number of items received. │ │ │ │ Enter Real Cost Factor: 0.0000 │ │ (ie: 0.012) │ └────────────────────────────────────────────────────────────────────────────┘ ■ AUTOMATIC DAILY INDEXING Daily, or if the index files are missing, DAYO Inventory will automatically index/reindex the index files (they have the file extension of '.EXT'). ┌────────────────────────[ AUTOMATIC DAILY INDEXING ]────────────────────────┐ │ If this option is set to Y (YES), then all DAYO Indexes accessed by │ │ DAYO Inventory will be recreated once daily. This will occur when the │ │ first DAYO Inventory program is run. The default is to recreate all │ │ all the indexes daily... │ │ │ │ Recreate all DAYO Inventory Indexes? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ VISUAL INDEXING If the Visual Indexing setting is set at 'Y', a progress graph will be displayed every time a character based index file is indexed/reindexed. ┌────────────────────────────[ VISUAL INDEXING ]─────────────────────────────┐ │ If you desire to see a progress graph each time your indexes are │ │ created, then select Y (YES). Note, the process can slow the indexing │ │ routine down; especially with larger databases. │ │ │ │ Do you wish to have Visual Indexing? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ┌──────────────────────────────────────────────────────────┐ │ Database Name: INV.DBF │ │ Index Name: INV.NTX │ │ Number of Records: 243 │ │ ┌──────────────────────────────────────────────────┐ │ │ │█████████████████████████████ │ │ │ └──────────────────────────────────────────────────┘ │ │ 0 ─ 10 ─ 20 ─ 30 ─ 40 ─ 50 ─ 60 ─ 70 ─ 80 ─ 90 ─ 100 % │ └──────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 68 ■ ALLOW BROWSE EDITING Very important! The last option on the Config screen is the option to allow/disallow the editing/changing of fields while in the Browse screens. Initially it is set to 'Y', allowing editing, but after getting your copy of DAYO Inventory set up, it is recommended that it be 'turned off'. This act will force the proper use of the purchase orders and receiving cycle! The setting of the 'Allow Browse Editing', in the Configuration module, to 'N', will cease the capability to edit fields while in the INVENTORY and PURCHASE ORDERS DETAIL browse screens. * Note, this option does not apply to the browse screens of the purchase order header, vendors, or MISC Routines. ┌──────────────────────────[ ALLOW BROWSE EDITING ]──────────────────────────┐ │ To disable editing while in a browse screen, select N (NO) to this │ │ option. Default is to allow it. │ │ │ │ Allow Editing While In A Browse Screen? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ DISPLAY WAREHOUSE VALUES ┌────────────────────────[ DISPLAY WAREHOUSE VALUES ]────────────────────────┐ │ If you desire to display the 1st seven warehouse quantities and │ │ stocklevels, then select Y (YES). │ │ The default is only display the 1st three. │ │ │ │ Do you wish to display the 1st seven warehouse quantities? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ CURRENT DIRECTORY DATABASE LOCATION ┌──────────────────[ CURRENT DIRECTORY DATABASE LOCATION ]───────────────────┐ │ This module's databases can be located in a different location other │ │ than the current directory. If you have and wish to use ALL the │ │ databases currently found in this directory from a different drive and │ │ directory, then you need to tell this module where to find them. │ │ Be sure to include the rightmost slash, ie: L:\DAYOINV\ │ │ The drive designation is optional if same as this module. │ │ │ │ Enter Location: \DAYOINV\ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 69 ■ GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY ┌────────────[ GENERAL LEDGER (GL) DATABASE LOCATION/DIRECTORY ]─────────────┐ │ The location of DAYO General Ledger Databases does not have to be │ │ in the same drive/directory as this module. If you have installed DAYO GL │ │ into a different directory, you need to tell this module where to find │ │ the GL databases. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOGL\ │ │ The drive designation is optional (if same as this module). │ │ │ │ Enter Location: \DAYOGL\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ CLOSE & DELETE FILLED PURCHASE ORDERS Note, set this option to Yes ONLY when DAYO Accounts Payable (AP) is NOT being utilized! ┌─────────────────[ CLOSE & DELETE FILLED PURCHASE ORDERS ]──────────────────┐ │ If you are NOT using DAYO AP and wish to close & delete filled Purchase │ │ Orders automatically at time of receipt, then select Y (YES). │ │ The default is to not close & delete; to let DAYO AP handle it. │ │ │ │ Do you want to close & delete filled POs? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ PRINT VENDITEM OR ITEM ONTO PURCHASE ORDER ┌───────────────[ PRINT VENDITEM OR ITEM ONTO PURCHASE ORDER ]───────────────┐ │ The VENDITEM number is (by default) printed onto purchase orders. │ │ You can override this and print the ITEM number instead by selecting │ │ N (No) to the following prompt... │ │ │ │ Do you want to print the field: VENDITEM onto POs? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ RECORD SERIAL NUMBERS UPON RECEIPT OF PRODUCT ┌─────────────[ RECORD SERIAL NUMBERS UPON RECEIPT OF PRODUCT ]──────────────┐ │ If you want to record serial numbers for items at time of receipt, then │ │ select Y (Yes) to this prompt. Default is NOT to record serial │ │ numbers at time of receipt. Note, items are flagged as serialized by │ │ setting the field: SERIALNO (in INV.DBF) to .T. or Yes. │ │ │ │ Do you want to record serial numbers? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 70 ■ AUTOMATIC GL POSTING This Configuration routine was added to allow you to post your transactions (ie: Invoice Posting, Cash Receipts, and Credit Memos), automatically into General Ledger (GL). If this option is set to 'Y' (Yes), each time you adjust or edit key accounting fields (ie: COST, AMOUNT, SUBTOTAL, FREIGHT, ADJUST, QTY...), a GL transaction records will be created. This routine includes an option to browse, edit, add, and/or delete records in the General Ledger Class Code Table/Database (GLCLASS.DBF). ╔══════════════════════════[ AUTOMATIC GL POSTING ]══════════════════════════╗ ║ If you are using General Ledger (GL), you can automatically update ║ ║ or create GL transactions every time you make an inventory adjustment. ║ ║ ║ ║ Do you want Automatic GL Posting? (Y/N) ║ ║ ║ ║ Default CLASS Code: AR Name: RECEIPTS ║ ║ Debit Account: 10000-000000 Credit Account: 20000-000000 ║ ║ Database: RECEIPTS.DBF Field: AMOUNT ║ ╟─────────────[ SELECT DEFAULT ACCOUNTS RECEIVABLE CLASS CODE ]──────────────╢ ║ CLASS NAME DEBIT CREDIT ║ ║──────────╥────────────────────────────────╥──────────────╥─────────────────║ ║ AR ║ Invoice Freight *** ║ 10000-000000 ║ 40000-000000 ║ ║ AR ║ 1st Invoice Tax *** ║ 10000-000000 ║ 40000-000000 ║ ║ AR ║ 2nd Invoice Tax *** ║ 10000-000000 ║ 40000-000000 ║ ║ AR ║ Invoice Adjustments *** ║ 10000-000000 ║ 40000-000000 ║ ║ AR ║ Invoice Paid/Collected *** ║ 10000-000000 ║ 40000-000000 ║ ║ REC ║ RECIPTS INTO INVENTORY ║ 91000-000000 ║ 20000-000000 ║ ║ INV ║ RECEIPTS INTO THE INVENTORY ║ 91000-000000 ║ 11000-000000 ║ ║ AR ║ RECEIPTS ║ 10000-000000 ║ 20000-000000 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete) Find: F5 (CLASS) F6 (DEBIT) F7 (CREDIT) F8 (NAME) F9 (DATABASE) 20/20 DAYO Inventory, TJS LAB Page: 71 ■ EDIT CLASS CODE RECORD Press 'F2' to edit a Class Code record. Note, valid entries are crucial to making this posting process work correctly... ╔═════════════════════════[ EDIT CLASS CODE RECORD ]═════════════════════════╗ ║ CLASS Code: AR ║ ║ Name: AR FREIGHT ║ ║ Debit Account: 11000-000000 ║ ║ Credit Account: 10000-000000 ║ ║ Database (.DBF): ARH.DBF ║ ║ Field: FREIGHT ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit) ■ ADD NEW CLASS CODE RECORD Press 'Ctrl N' to add a new CLASS code record. ╔═══════════════════════[ ADD NEW CLASS CODE RECORD ]════════════════════════╗ ║ CLASS Code: ║ ║ Name: ║ ║ Debit Account: 00000-000000 ║ ║ Credit Account: 00000-000000 ║ ║ Database (.DBF): INVADJ.DBF ║ ║ Field: ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) F1 (Help) PgUp/PgDn (Save & Exit) DAYO Inventory, TJS LAB Page: 72 ■ FIND CLASS CODE Use the 'F5' through 'F9' keys to locate a desired CLASS code record Press 'F5' to locate a CLASS code record based on the CLASS field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter CLASS+DATABASE: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F6' to locate a CLASS code record based on the DEBIT field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter DEBIT: 30000-200000 │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F7' to locate a CLASS code record based on the CREDIT field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter CREDIT: 10000-200000 │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F8' to locate a CLASS code record based on the NAME field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: │ └───────────────────────────────────────────────────TJS LAB───┘ Press 'F9' to locate a CLASS code record based on the DATABASE field, ie: ┌─────────────────────────────────────────────────────────────┐ │ Enter DATABASE: │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO Inventory, TJS LAB Page: 73 ■ DEFAULT INVENTORY ITEM TYPE CODE ┌───────────────────[ DEFAULT INVENTORY ITEM TYPE CODE ]─────────────────────┐ │ │ │ Enter Default Inventory Item TYPE Code (ie: 'INV'): INV │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ DEFAULT INVENTORY ITEM CLASS CODE ┌──────────────────[ DEFAULT INVENTORY ITEM CLASS CODE ]─────────────────────┐ │ │ │ Enter Default Inventory Item CLASS Code (ie: 'INV'): INV │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR MONITOR If you have a color monitor and wish to display colors, select 'Y' (YES), or select 'N' (NO) for monochrome. The default is color, low intensity. ┌─────────────────────────────[ COLOR MONITOR ]──────────────────────────────┐ │ If you have a color monitor and wish to display colors, then select Y, │ │ (YES), else select N (NO) for monochrome and others. │ │ The default is color, low intensity │ │ │ │ Do you have a color monitor? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR INTENSITY If you have a color monitor and want high intensity colors, select 'Y' for the high intensity. The default is 'N' (NO), low intensity colors. ┌────────────────────────────[ COLOR INTENSITY ]─────────────────────────────┐ │ Intensity is only applicable with color set to Y. │ │ It will make your colors brighter... │ │ │ │ Set Color Intensity On? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 74 ■ MISCELLANEOUS ROUTINES The MISC routines is a collection of 17 very useful Database Management Routines. These routines provide you with the 'ability to do whatever was left out of the rest of the program...'. These routines were modeled after dBase (tm) III+/IV functions. Familiarity with dBase will help with the understanding and execution of these routines. USE WITH CAUTION! YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES YOU CAN ALSO MESS THINGS UP PERMANENTLY! ■ MISC ROUTINES MENU: DAYO INVENTORY Version 3.0 TJS LAB ┌───[February 1991]──┐ ╔════════════════════╗ │S M T W T F S │ ║ MISC ROUTINES ║ ├────────────────────┤ ╟────────────────────╢ ████▄ ▄█▄ █░ █░ ▄██▄ │ 1 2│ ║ APPEND FROM ║ █░ █░ █░█░ █░ █░ █ █░ │ 3 4 5 6 7 8 9│ ║ BROWSE DATABASES ║ █░ █░ █░█░ ▀█░██ █ █░ │10 11 12 13 14 15 16│ ║ COPY (.DBF) TO ║ █░ █░ █▀▀▀█░ ▀█▀ █ █░ │17 18 19 20 21 22 23│ ║ CREATE DATABASE ║ █░ █░ █░ █░ █░ █ █░ │24 25 26 27 28 29 30│ ║ DELETE RECORDS ║ ████▀ █░ █░ █░ ▀██▀ │31 │ ║ ERASE FILE ║ └────────────────────┘ ║ EXIT TO DOS ║ ╓────────────────────────────────────────────────╖ ║ INDEX A DATABASE ║ ║ DAYO INVENTORY STATISTICS ║ ║ LIST FIELDS ║ ╟────────────────────────────────────────────────╢ ║ PACK DATABASE ║ ║ DATABASE NAME RECORDS SIZE ║ ║ MODIFY DATABASE ║ ╟────────────────────────────────────────────────╢ ║ RECALL RECORDS ║ ║ INV.DBF Inventory 242 38K ║ ║ RETURN TO MENU ║ ║ POH.DBF PO Header 11 5K ║ ║ RUN (DOS COMMAND ║ ║ POD.DBF PO Detail 21 3K ║ ║ SIMPLE EDITOR ║ ║ VENDORS.DBF Vendors 18 5K ║ ║ SORT DATABASE ║ ║ REC.DBF Receiving 20 4K ║ ║ TYPE (PRINT) FIL ║ ║ INVADJ.DBF Adjustments 6 1K ║ ║ ZAP DATABASE ║ ║ WAREHOUS.DBF Warehouse Qty 6 1K ║ ╟────────────────────╢ ║ WARENAME.DBF Warehouse Names 7 1K ║ ║ Select Option ║ ╚════════════════════════════════════════════════╝ ╚════════════════════╝ DAYO Inventory, TJS LAB Page: 75 ■ APPEND FROM Used to copy records from one database into another database, or to create records from ASCII files (SDF or DELIMITED). The Initial Screen will prompt you to enter the file name of the database you are to append/copy the data into. At this point, you can either type in the name of the target database, or ... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ └────────────────────────────────────────────────────────────────────────────┘ If it exists in the current directory, press enter on an empty prompt to display all databases to select from. ┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │INVENT.DBF │ 375 │ 09/16/89 │ │ │ │AR.DBF │ 7219 │ 09/16/89 │ │ │ │HISTORY.DBF │ 103 │ 09/16/89 │ │ │ │PERSONS.DBF │ 24271 │ 09/16/89 │ │ │ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ │ │ └───────────────────────────────────────────────────────────────────────────┘ The next prompt will be to select the type of Append: ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ └──────────────────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 76 If you are appending from another database (.DBF) then select 'Standard'. Select the SDF option if you are appending from a 'flat' ASCII file. Select the DELIMITED option if you are appending from a delimited ASCII file. Delimited files contain records in which the fields are separated by commas, and its character fields contained in double quotes... If you select a Standard Append, you will then be prompted to enter the name of the database you wish to get the data from. If you selected the SDF or DELIMITED options, then enter the file name containing the data to be appended into your target database. ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into PERSONS.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: PERSON1.TXT │ │ │ │ │ └──────────────────────────────────────────────────────────────────────────┘ The number of records appended into the target database will be displayed upon completion of the task... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF From INVENTY.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: INVENTY.DBF │ │ │ │ │ │ │ │ There Were 1 Records Appended Into INVENT.DBF │ │ │ │ │ │ │ │ Press Any Key To Continue... │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 77 ■ BROWSE DATABASES Used to edit/view records in a database. Enter the database name you wish to edit/browse, or if it exists in the current directory, press enter on an empty prompt to bring up a window box to select from. ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: INVENT.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ If there exists an index (.NDX or .NTX), with the same name as the database, it will be utilized... The DAYO Inventory indexes are the exception. They are automatically set/used. An example of a browse screen: TJS LAB, PO BOX 585366 ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ MFG_PART DESC PRICE LIST │ │──────────────────╥────────────────────────────────╥────────────╥───────────│ │ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │ │ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │ │ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │ │ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │ │ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │ │ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │ │ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │ │ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │ │ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │ │ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │ │ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │ │ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │ │ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │ │ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │ │ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │ │ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │ │ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │ ├──────────────────╨────────────────────────────────╨────────────╨───────────┤ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ 51/60 DAYO Inventory, TJS LAB Page: 78 To edit a memo field, just highlight the field, and start typing. * * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING! ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ PRICE LIST YOURPART NOTES │ │───────────────────────╥────────────╥─────────────────╥─────────────────────│ │ 896.16 ║ 1792.32 ║ ║ <Memo> │ │ 1064.19 ║ 2128.38 ║ ║ <Memo> │ │ 672.12 ║ 1344.24 ║ ║ <Memo> │ │ 1736.31 ║ 3472.62 ║ ║ <Memo> │ │ 504.09 ║ 1008.18 ║ ║ <Memo> │ │ 784.14 ║ 1568.28 ║ ║ <Memo> │ │ 1400.25 ║ 2800.50 ║ ║ <Memo> │ ┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐ │You can edit memo fields too... │ │ │ │ │ │ │ │ │ │ │ │ │ └───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ Special keys for 'moving around' the BROWSE screen are: Left Arrow Key - Move to next field to your left Right Arrow Key - Move to next field to your right Ctrl Home - Go to the leftmost field Ctrl End - Go to the rightmost field (on the end of the record) Up Arrow - Move highlight to the previous record Down Arrow - Move highlight to the next record PgUp - Page up a full screen of records PgDn - Page down a full screen of records Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end or last record of the file Ctrl N - Add a record (where applicable) Ctrl U - Delete a record (where applicable) F5 - To seek/find a record based upon the active index Esc - Exit the current operation Remember that there are many more fields to the right of the screen. Press the right arrow key to view them... DAYO Inventory, TJS LAB Page: 79 ■ COPY (.DBF) TO Copy records to another (new) database. Use this option to copy select records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can also be used to create backups of data (IE: copy to floppy). ┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │HARPS.DBF │ 375 │ 09/16/89 │ │ │ │INVENT.DBF │ 7335 │ 09/16/89 │ │ │ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │ │ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │ │ │AP.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ The next prompt will be to select the type of COPY TO option you want: ┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: INVENT.DBF │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ │ │ Copy Records From INVENT.DBF │ └────────────────────────────────────────────────────────────────────────────┘ The Standard option is simply creating another database (.DBF). The SDF and DELIMITED options will create ASCII files. The STRUCTURE option creates a new database with the same file structure as the initial database (no records copied). DAYO Inventory, TJS LAB Page: 80 The next prompt (optional), requires some knowledge of dBase (tm). This prompt is requesting the user to enter a condition or filter. If all records are to be copied, just press Enter on an empty prompt. ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW.DBF │ │ │ │ Enter Condition: │ │ Sample condition: COST > 100 │ │ │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ This 'Condition' option is useful for coping only specific records into a new location. Any valid dBase/Clipper statement (as shown next) is fine... ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW DBF │ │ │ │ Enter Condition: PRICE>0 │ │ Sample condition: COST > 100 │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 81 The following window message will appear while the COPY TO routine does its task: ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW10 │ │ │ │ Enter Condition: PRICE>0 │ │ Sample cond┌───────────────────────────────────────────────┐ │ │ │┌─────────────────────────────────────────────┐│ │ │ CONDITION: ││┌───────────────────────────────────────────┐││ │ │ │││┌─────────────────────────────────────────┐│││ │ │ ││││Hold those camels while I do this COPY TO││││ │ │ │││└─────────────────────────────────────────┘│││ │ │ ││└───────────────────────────────────────────┘││ │ │ │└─────────────────────────────────────────────┘│ │ │ └───────────────────────────────────────────────┘ │ │ Copy Records From SDF To NEW10 │ └────────────────────────────────────────────────────────────────────────────┘ ■ CREATE DATABASE Create a new database. This routine lets you create entirely new database structures. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ ║ ║ 0 ║ 0 │ │ ║ ║ ║ │ │ ║ ║ ║ │ ┌─────────────│ ║ ║ ║ │────────────┐ │ │ ║ ║ ║ │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO Inventory, TJS LAB Page: 82 * * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * * IT IS SLIGHTLY BOTHERSOME SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING... *** If any error is made in this routine, you will experience an error, either immediately, or when you start to edit the new database. This error may even cause your computer to hang! *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ NAME ║ C ║ 30 ║ 0 │ │ AGE ║ N ║ 5 ║ 1 │ │ DEAD ║ L ║ 1 ║ 0 │ │ BIRTHDATE ║ D ║ 8 ║ 0 │ ┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐ │ │ ║ ║ 0 ║ 0 │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │ ║ ║ ║ │ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO Inventory, TJS LAB Page: 83 ■ DELETE RECORDS Delete selected records from databases. The first prompt is for the name of the database you wish to mark records for deletion. Like many of the other routines, you can press enter on an empty prompt to bring up all databases that exist in the current directory: ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │D.DBF │ 259 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/16/89 │ │XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └────────────────────────────────────────────────────────────────────────────┘ After selecting the database, all its fields will be presented atop the screen so as to aid the user in entering a condition/filter. The use of the condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax is required. Note the use of the Clipper Function: EMPTY(). ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐ │ Enter Database Name: TRASH │ │ Delete Records For Condition: EMPTY(PART) │ │ Sample condition: COST > 100 │ │ CONDITION: EMPTY(PART) │ │ Number of Records Deleted: 208 │ │ Press any key to continue... │ └────────────────────────────────────────────────────────────────────────────┘ The number of records deleted will be displayed upon the screen as depicted just above... DAYO Inventory, TJS LAB Page: 84 ■ ERASE FILE Erase a file (forever!). Use this option with extreme care! Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY REMOVED FROM EXISTENCE NO SECOND CHANCES HERE... The first prompt is for the file name. You can press enter on an empty prompt to bring up a window selection of all files in the current directory. ┌────────────────────────┐ ┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘ │BKDOOR.DOC │ 37029 │ 09/17/89 │ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │D.DBF │ 259 │ 09/16/89 │ │D.DBT │ 512 │ 09/16/89 │ │DAYOBK.BAK │ 36879 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ │DAYOBK.OBJ │ 35585 │ 09/16/89 │ │DAYOCAL.MAP │ 35 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │DDD.DBT │ 512 │ 09/16/89 │ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More * To ERASE a file, just highlight it, then press Enter... ■ EXIT TO DOS This option will close all open files and databases and exit to DOS without having to return to the main menu exit routine. DAYO Inventory, TJS LAB Page: 85 ■ INDEX A DATABASE You will be prompted to select the database you wish to index. After selecting the database, by typing in the name or pressing Enter on an empty prompt (then selecting from the window), you will be given a listing of all fields in that database atop the screen. ┌────────[ PICK A DATABASE ]───────────┐. │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DAD.DBF │ 259 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SPW.DBF │ 7335 │ 09/16/89 │ │SOW.DBF │ 103 │ 09/16/89 │ │BOY.DBF │ 24387 │ 09/17/89 │ │SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ You will now be prompted to enter the name of the Index File. It will be (by default), named exactly the same as the selected database, with the exception of the extension. This will default to .NDX or .NTX depending on whether you linked NDX.OBJ with your application. *** Remember that the BROWSE routine only looks at indexes with the same name as the database. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ └───────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 86 At the prompt for the index key, enter a field name, or a valid dBase/Clipper expression. ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ │ Enter the Key Expression: PART+MFG_PART │ └───────────────────────────────────────────────────────────────┘ ■ LIST FIELDS List fields to screen or printer. This routine is a great tool for providing simple reports and lists. The first prompt will be for the database you wish to work with. Type the name of the file, or press Enter on an empty prompt to bring up a window of all databases in the current directory for selection. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │INVEND.DBF │ 259 │ 09/16/89 │ │INVENT.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SOMEDAY.DBF │ 7335 │ 09/16/89 │ │TANGO.DBF │ 103 │ 09/16/89 │ │AP.DBF │ 24387 │ 09/17/89 │ │BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 87 The next prompt is for a condition or filter. This makes it possible to list only specific records that meet that condition you enter. The condition must be a valid dBase/Clipper expression, or none (to list all). ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌─────────────────────────────────────────────────────┐ │ Enter Filter: │ │ IE: ID = "SAM0909" .AND. RETAIL > 10000 │ └─────────────────────────────────────────────────────┘ ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: │ │ │ └───────────────────────────────────────────────────────────────┘ A window box appears next displaying all the fields in the selected database and an option to list all fields. Highlight any combination of fields ( or ALL) that you want listed. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║ ├─────────────────┤ ║ ╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝ │RECNO() │ │MFG_PART │ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 88 The fields you select will be displayed at center top of screen. Press Esc to exit the "PICK THE FIELDS YOU WANT LISTED" window. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ At the next prompt, you can send the list to the SCREEN, PRINTER OR FILE. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │DESC┌──────────────────────────────────────────────────────────────────┐ │PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │ │LIST│ │ │YOUR└──────────────────────────────────────────────────────────────────┘─┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 89 The list is very simple, and if displayed onto the screen, may look like the following: PART MFG_PART PRICE 4523 0.00 DAYO9S 41926 1904.34 DAYO10S 13564 616.11 DAYOCOMP 45625 2072.37 DAYOALLS 43159 1960.35 INDEXER 50558 2296.41 INDEXERS 51791 2352.42 5 DEMO 4932 224.04 DAYO13S 20963 952.17 MENUS 53024 2408.43 OFFSITEP 56724 2576.46 ONSITEP 57957 2632.47 DAYO2S 24662 1120.20 DAYO9 40693 1848.33 DAYO10 12331 560.10 DAYOCAL$ 44392 2016.36 DAYO13 19730 896.16 DAYO2 23429 1064.19 DAYO11 14797 672.12 DAYO8 38227 1736.31 DAYO1 11098 504.09 DAYO12 17264 784.14 DAYO5 30828 1400.25 ......PRESS ANY KEY TO CONTINUE...... ■ MODIFY DATABASE Change the fields/structure of a database. You can add new fields, delete fields, change the length and type of field in any of the databases. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ******************************************************** *** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST *** *** IT IS SLIGHTLY BOTHERSOME SORRY! *** ******************************************************** *** If any error is made in this routine, you will experience an error, either immediately, or when you start to access the database. This error may even cause your computer to hang! DAYO Inventory, TJS LAB Page: 90 *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ■ PACK DATABASE Pack a database (removed deleted records). This option will permanently remove any records marked for deletion. This is another routine you should use with great care! As in many of the other of the routines, you will be prompted to enter the name of the database you wish to pack. Enter the name or press Enter on an empty prompt to view the window. ┌─────┐ │PACK!│ └─────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │GOODDATA.DBF │ 259 │ 09/16/89 │ │HAP.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │LOIN.DBF │ 103 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/17/89 │ │FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ After selecting the database, you will be prompted to respond with a Yes or No (to Pack or not to Pack...). This is the last chance you have to change your mind... ┌──────────────────────────────────────────────────────────────────────────┐ │ PACK TOM3 │ │ Are you sure you want to PACK (remove deleted records) ? N │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 91 ■ RECALL RECORDS Recalls records previously marked for deletion. This option is identical to the DELETE RECORDS option discussed earlier... ■ RETURN TO MENU Returns to the procedure that called MISC Routines. ■ RUN (DOS COMMAND) Run a DOS command (EG: dir/w). This option is helpful in that it allows you to run programs at the DOS level (within memory constraints). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN CD\DOS │ └───────────────────────────────────────────────────────────────────────────┘ One useful option is to type and Enter: COMMAND at this prompt. You will be running another DOS Shell totally out of the program (it still is in memory though). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN COMMAND │ └───────────────────────────────────────────────────────────────────────────┘ Press and Enter: EXIT to return to your Clipper Application. DAYO Inventory, TJS LAB Page: 92 ■ SIMPLE EDITOR A simple editor and word processor. Use this option to create and read simple TEXT files. File size is limited to your machines capabilities or 32,000k. The first prompt is for the name of the file you wish to edit. Type in the name, or press Enter on an empty prompt to bring up a window option box containing all files in the current directory. ┌────────────────────────┐ ┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ ┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐ │ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │ │ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │ └────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ │DEMO.MAP │ 7780 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More *** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...), so be careful at what you select for viewing/editing. If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE those changes. If you exit with an Esc, all changes will be lost! ┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐ │CLIPPER demo │ │CLIPPER MISC │ │KWAIT 10 │ │LIB MISC-+MISC,MISC.LST,MISC │ │KWAIT 10 │ │TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │ │KWAIT 10 │ │DEMO │ └────────────────────────────────────────────────────────────────────────────┘ Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0 DAYO Inventory, TJS LAB Page: 93 Special keys for 'moving around' the SIMPLE EDITOR screen are: Left Arrow Key - Move to your left Right Arrow Key - Move to your right Ctrl Home - Go to the top, leftmost corner of window Ctrl End - Go to the bottom, rightmost corner of window Up Arrow - Move up one line Down Arrow - Move down one line PgUp - Page up a full screen PgDn - Page down a full screen Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end of the file * F2 - Import text from a text file * Ctrl W - Save Changes and Exit * Esc - ABORT Changes and Exit The margin may exceed the boundaries on the right side of the screen, but the text is easily accessed using the special keys above... ■ SORT DATABASE This option takes a database, sorts it, and copies the result into a new database. The first prompt is for the name of the database you want to sort. Enter the name, or press Enter on an empty prompt to bring up a window box containing all databases in the current directory. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DOG.DBF │ 259 │ 09/16/89 │ │CAT.DBF │ 375 │ 09/16/89 │ │CAR.DBF │ 195 │ 09/17/89 │ │BAM.DBF │ 7335 │ 09/16/89 │ │HARP.DBF │ 103 │ 09/17/89 │ │TRAIN.DBF │ 24387 │ 09/17/89 │ │HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └───────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 94 The next prompt is for the name of the database you will be creating with the sorted data. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: INVNET.DBF │ │ Enter Name of Sorted File: INVNET1.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ The next prompt is for the sort field (limited to 1 field)... ╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: TOM.DBF │ │ Enter Name of Sorted File: TOM1.DBF │ │ Enter the Key Expression: PART │ └───────────────────────────────────────────────────────────────┘ ■ TYPE (PRINT) FILE Prints an ASCII/text file to screen or printer. The first prompt is for the file name. ┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐ │ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │ │ Press Enter/Return on an empty field to get a current directory listing. │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 95 The display of the file (any type), is continuous, but can be paused by any key (except the Enter & Esc keys). Pressing the Enter key will slow the printing of the file onto the screen. Press Esc to Abort the display... A sample display: FUNCKEY...........MISC FUNIQUE...........MISC FZAP..............MISC GET_PIC1..........MISC ISDATA............MISC ISDBF.............MISC MENU_KEY..........MISC MISC..............MISC OKFILE............MISC PACKIT............MISC PICKDBF...........MISC PROCLIST..........MISC SHOW_INS2.........MISC STATLINE2.........MISC TOG_INS2..........MISC XKEY_CLEAR........MISC XKEY_NORM.........MISC XMEMO.............MISC MISC BKDOOR BROWSEIT CENTER1 COLORSET DBFUNCT DBFUNCT6 EDITOR FACHOICE FAPPEND FCOPY2 FDBF1 FDELETE FERASE FILESZ FILE_UDF FILT FINDER FINDEX FMAKEDB FMODYDB FNEW FRECALL FRUN FSCROLL1 FSORT FTYPEIT FUNCKEY FUNIQUE FZAP GET_PIC1 ISDATA ISDBF MENU_KEY MISC OKFILE PACKIT PICKDBF PROCLIST SHOW_INS2 STATLINE2 TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO PRESS ANY KEY TO CONTINUE... ■ ZAP DATABASE Totally erase all records in database (forever!). When you want to remove every record from a database, then use this option. Use with EXTREME CAUTION! The first prompt is for the file name. Enter the name of the database you are to 'clean out', or press Enter to select the database from a window containing all databases in the current directory. DAYO Inventory, TJS LAB Page: 96 ┌────┐ │ZAP!│ └────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DENVER.DBF │ 259 │ 09/16/89 │ │OHIO.DBF │ 375 │ 09/16/89 │ │NEWYORK.DBF │ 195 │ 09/17/89 │ │MONTANA.DBF │ 7335 │ 09/16/89 │ │SC.DBF │ 259 │ 09/17/89 │ │EARS.DBF │ 103 │ 09/17/89 │ │FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐ │MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │ │CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │ └──────────────┴────────────┴──────────┘───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ You will be prompted one last time as to whether you still want to ZAP the selected database. Press Y for Yes, N for No... ┌────┐ │ZAP!│ └────┘ ┌──────────────────────────────────────────────────────────────────────────┐ │ ZAP TRASH │ │ Are you sure you want to ZAP (remove all records permanently) ? N │ │ │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 97 ■ HELP SCREENS While in the browse screens, some of the option windows, and in the SIMPLE EDITOR, pressing the F1 key, will display a help screen. BROWSE help: ┌──────────────────────[ DAYOINV HELP: DBEDIT, 0, ]─────────────────────────┐ │ │ │- Special keys for 'moving around' the BROWSE screen are: │ │ │ │ Left Arrow Key - Move to next field to your left │ │ Right Arrow Key - Move to next field to your right │ │ Ctrl Home - Go to the leftmost field │ │ Ctrl End - Go to the rightmost field (on the end of the record)│ │ Up Arrow - Move highlight to the previous record │ │ Down Arrow - Move highlight to the next record │ │ PgUp - Page up a full screen of records │ │ PgDn - Page down a full screen of records │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end or last record of the file │ │ Ctrl N - Add a record (where applicable) │ │ Ctrl U - Delete a record (where applicable) │ │ F5,F6,F7 - To seek/find a record based upon the active index │ │ Esc - Exit the current operation │ │ │ │ Remember that there are many more fields to the right of the screen. │ │ Press the right arrow key to view them... │ └────────────────────────────────────────────────────────────────────────────┘ Option Box Help: ┌───────────────────────[ DAYOINV HELP: ACHOICE, 0, ]───────────────────────┐ │ │ │ │ │ │ │ │ │ - Special keys for 'moving around' the Option Box are: │ │ │ │ Up Arrow - Move up one option │ │ Down Arrow - Move down one option │ │ PgUp - Page up multiple records │ │ PgDn - Page down multiple records │ │ Esc - ABORT and Exit │ │ │ │ │ │ After highlighting the option you desire, press Enter... │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO Inventory, TJS LAB Page: 98 Editor help: ┌──────────────────────[ DAYOINV HELP: MEMOEDIT, 0, ]───────────────────────┐ │ │ │ - Special keys for 'moving around' the EDITOR screen are: │ │ │ │ Left Arrow Key - Move to your left │ │ Right Arrow Key - Move to your right │ │ Ctrl Home - Go to the top, leftmost corner of window │ │ Ctrl End - Go to the bottom, rightmost corner of window │ │ Up Arrow - Move up one line │ │ Down Arrow - Move down one line │ │ PgUp - Page up a full screen │ │ PgDn - Page down a full screen │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end of the file │ │ Ctrl W - SAVE Changes and Exit │ │ Esc - ABORT Changes and Exit │ │ F2 - Import another text file into your document │ │ │ │ The margin may exceed the boundaries on the right side of the screen, │ │ but the text is easily accessed using the special keys above... │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ EXPANDED HELP After Version 1.3, expanded help routines were added to all DAYO modules. At almost all prompts and menus you can press F1 for help. Help can be a function key message as displayed on previous page, a message that you have created (user defined & inputted), or the ability to read the documentation on the screen (saves paper). DAYO Inventory, TJS LAB Page: 99 ■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES If you press F1 and no user defined & inputted message exists for that section of the program you are currently in you will receive a message to this effect, and then a blank/empty screen. The editing keys for this option are the same as for the Simple Editor (previous page). DAYO INVENTORY Version 3.0 TJS LAB ┌───[February 1991]──┐ ┌──────[ DAYO HELP Called by Program: DAYOINV Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ │ │ │ │ ╔════════════════════════════════════════════════════════╗ │ │ ║ No Online Help Messages Exist for this prompt... ║ │ │ ║ ║ │ │ ║ You can type in any help message you wish, or ║ │ │ ║ press F1 to view the document for DAYOINV. ║ │ │ ║ ║ │ │ ║ ║ │ │ ║ Press any key to continue... ║ │ │ ╚════════════════════════════════════════════════════════╝ │ │ │ │ │ ├───────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │ └───────────────────────────────────────────────────────────────────────────┘ If you wish to input anything at this point, just type whatever you wish, remembering to press Ctrl W to save all changes. Pressing Esc will not save ANY changes ( all effort you put into writing a help message will be lost! ). DAYO Inventory, TJS LAB Page: 100 DAYO INVENTORY Version 3.0 TJS LAB ┌───[February 1991]──┐ ┌───────[ DAYO HELP Called by Program: DAYOINV Variable: OPT ]───────┐ │ │ │ │ │ │ │ Type in anything you wish about this portion of the program! │ │ │ │ The length of this file can be many pages... │ │ │ │ Be sure to press Ctrl W to save any changes/additions you make to this │ │ screen. │ │ │ │ │ │ │ │ │ │ │ │ │ ├────────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │ └────────────────────────────────────────────────────────────────────────────┘ ■ VIEW DOCUMENTATION ON SCREEN To view the documentation for the module you are in, it must first exist in the current directory. Document files are named the same as the module, and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOPOS.DOC, DAYOPAY.DOC. Press F1 in the User Defined & Inputted Help Message screen to display the document (user manual). The special keys in this option are displayed in the Help Screen (press F1 again) for this option: ╔══════════════════════════════════════════════════════════════════════════╗ ║ While viewing the document for DAYOINV the keyboard is configured ║ ║ as followed: ║ ║ ║ ║ Esc Exit ║ ║ F5 Find a string. This search is not case sensitive ║ ║ Examples: Page 50 ║ ║ INTRODUCTION ║ ║ REPORTS ║ ║ Home Return to the beginning of the document ║ ║ End Go to the bottom of the document ║ ║ PgUp Page up ║ ║ ║ ║ Any other key moves acts like PgDn (page down) ║ ║ ║ ║ Press any key to continue... ║ ╚══════════════════════════════════════════════════════════════════════════╝ DAYO Inventory, TJS LAB Page: 101 ■ DAYO INVENTORY MAINTENANCE & QUIRKS After using DAYO Inventory for a period, you will need to 'clean out' deleted and filled purchase orders, deleted vendors, and deleted inventory and warehouse records. Generally this task is accomplished on a scheduled date sometimes called 'End of Month' (EOM), or 'End of Period' (EOP). The period may be daily, weekly, monthly, quarterly, or yearly. Deleted records should remain in their respected databases until this time to allow for organized record keeping. At this time, reports covering the period could be printed as well as backups of the databases. The backup is especially important since the next step is to permanently remove the deleted records with the PACK option in the MISC routines. At EOM/EOP time, the SOLDPTD field in the inventory database (INV.DBF) should be set to zero. Note that this field is maintained/adjusted by the use of the Inventory Adjustments option in the inventory browse screen, and optionally by using DAYO_POS (Point of Sale, Billing & Invoicing). On occasion, index files will get corrupted, especially on networks. To 'fix' a corrupted index requires that everyone 'get out of' the DAYO databases, and then to perform a reindexing (actually a recreation of the indexes). The reindex is accomplished by running the DAYO Inventory program with a parameter of 'INDEX'. ie: C:\>DAYOI INDEX If you are on a multiuser network, you must 'flag' (change file attributes) of all files to make them sharable, readable and writable. Note that the command/program 'flag' may be called by a different name on your network. ie: E:\>FLAG *.NTX SRW or just to be safe, go ahead and flag all files in the DAYO directory: E:\>FLAG *.* SRW Indexes are recreated once every day. This is automatically performed by the first user to run DAYOINV. This process can take more time as your files get larger. This process should take place daily, but you can run it at night with a batch file that waits until after midnight, or with a scheduling program. All other users must be out of the system, or the procedure will not occur. Remember to flag the files sharable, readable and writable. Remember to archive your receiving database (REC.DBF), and the inventory adjustments database (INVADJ.DBF). These databases grow with every receipt of product and inventory adjustment (respectively). This archive usually takes place at the 'End of Period/Month'. DAYO Inventory, TJS LAB Page: 102 A simple method of archiving the receiving database (REC.DBF), and the inventory adjustments database (INVADJ.DBF), is to copy/backup the files, then use the ZAP function in the MISC routines (remove all records from them). Always insure a good backup before a ZAP! Backups of your data and configuration files should take place daily! You have no doubt heard many scare stories. They are all true! The key files that need to be backed up all have the extension of .DBF, and .CFG. The .DBF files are your databases. The .CFG is the file that contains your configuration information (as seen in the Configuration module). If you are on a network, it is NOT recommended that you use dBase III+ with the databases. It may write an end of file marker not always recognized by DAYO. Appending additional records to the database after this point often leads/creates a 'bad record' in the database. If you are using dBase with DAYO Inventory, be sure to SET EXCLUSIVE OFF before you open ANY databases. This will allow the opened databases to be shared, and more importantly, prevent a user (or all users!) from 'crashing'! If the SIMPLE EDITOR tends to 'hang' your CPU, even on small files, then do not use it... Hope to fix this 'feature' with the next upgrade... DAYO Inventory, TJS LAB Page: 103 ■ FILES DAYO Inventory requires the following files to be present in the same directory in order to operate: Documentation File (this manual) DAYOINV.DOC Program File: DAYOINV.EXE Configuration File: DAYOINV.CFG Databases: INV.DBF VENDORS.DBF POD.DBF POH.DBF REC.DBF WAREHOUS.DBF WARENAME.DBF INVADJ.DBF Report Forms: INVADJ.FRM WAREHOUS.FRM REORDER.FRM EXPANDED.FRM MOVEMENT.FRM POH.FRM POD.FRM VENDORS.FRM REC.FRM DAYO Inventory, TJS LAB Page: 104 Index Files: INV.NTX Index files for INV.DBF (Inventory) DESC.NTX VENDOR.NTX VENDITEM.NTX INVTYPE.NTX VENDORS.NTX Index files for VENDORS.DBF VENDNAME.NTX POD.NTX Index files for POD.DBF (Purchase Order Detail) PODITEM.NTX PODVEND.NTX PODVENDI.NTX POH.NTX Index files for POH.DBF (Purchase Order Headers) POHNAME.NTX POHVEND.NTX REC.NTX Index files for REC.DBF (Receiving) RECPO.NTX RECITEM.NTX RECVENDI.NTX WAREHOUS.NTX Index file for WAREHOUS.DBF (Warehouse Quantities) WARENAME.NTX Index file for WARENAME.DBF (Warehouse Names) DAYO Inventory, TJS LAB Page: 105 ■ DATABASE STRUCTURES DAYO Inventory consists of eight databases. There default structures are: Structure for database: INV.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 ITEM Character 12 1 12 2 DESC Character 30 13 42 3 DESC2 Character 30 43 72 4 ONHAND Numeric 7 73 79 5 ALLOCATED Numeric 7 80 86 6 ONORDER Numeric 7 87 93 7 BO Numeric 7 94 100 8 SOLDPTD Numeric 7 101 107 9 SOLDYTD Numeric 7 108 114 10 VENDITEM Character 12 115 126 11 VENDOR Character 10 127 136 12 DATE Date 8 137 144 13 LASTDATE Date 8 145 152 14 COST Numeric 10 2 153 162 15 AVGCOST Numeric 10 2 163 172 16 REALCOST Numeric 10 2 173 182 17 RETAIL Numeric 10 2 183 192 18 PRICE Numeric 10 2 193 202 19 PRICE1 Numeric 10 2 203 212 20 PRICE2 Numeric 10 2 213 222 21 PRICE3 Numeric 10 2 223 232 22 PRICE4 Numeric 10 2 233 242 23 PRICE5 Numeric 10 2 243 252 24 STOCKLEVEL Numeric 7 253 259 25 MIN Numeric 7 260 266 26 TYPE Character 3 267 269 27 CLASS Character 3 270 272 28 TAXABLE Logical 1 273 273 29 SERIALNO Logical 1 274 274 30 WEIGHT Numeric 8 2 275 282 31 UNIT Character 3 283 285 32 UNITQTY Numeric 7 286 292 33 PACKQTY Character 6 293 298 34 BOM Logical 1 299 299 35 NS Logical 1 300 300 36 TI Logical 1 301 301 37 LOCATION Character 3 302 304 ────────── ───── Total 305 DAYO Inventory, TJS LAB Page: 106 Structure for database: INVADJ.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 ITEM Character 12 1 12 2 VENDITEM Character 12 13 24 3 QTY Numeric 7 25 31 4 COST Numeric 10 2 32 41 5 PRICE Numeric 10 2 42 51 6 RETAIL Numeric 10 2 52 61 7 DOLLARS Numeric 10 2 62 71 8 REASON Character 30 72 101 9 LOC Character 10 102 111 10 BY Character 30 112 141 11 DATE Date 8 142 149 12 CLASS Character 3 150 152 13 TRANSACT Character 12 153 164 ───── ────────── ───────── ───── ─── ───── ─── Total 165 DAYO Inventory, TJS LAB Page: 107 Structure for database: POD.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 PO Numeric 6 1 6 2 VENDOR Character 10 7 16 3 ITEM Character 12 17 28 4 DESC Character 30 29 58 5 VENDITEM Character 12 59 70 6 ORDERED Numeric 7 71 77 7 RECEIVED Numeric 7 78 84 8 COST Numeric 10 2 85 94 9 DATE Date 8 95 102 10 ETA Date 8 103 110 11 LASTRECV Date 8 111 118 12 TYPE Character 3 119 121 13 CLASS Character 3 122 124 14 OPEN Logical 1 125 125 15 TAXABLE Logical 1 126 126 ───── ────────── ───────── ───── ─── ───── ─── Total 127 DAYO Inventory, TJS LAB Page: 108 Structure for database: POH.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 PO Numeric 6 1 6 2 VENDOR Character 10 7 16 3 NAME Character 30 17 46 4 ATTN Character 30 47 76 5 ADDR1 Character 30 77 106 6 ADDR2 Character 30 107 136 7 CITY Character 22 137 158 8 STATE Character 2 159 160 9 ZIP Character 10 161 170 10 PHONE Character 14 171 184 11 SHIPNAME Character 30 185 214 12 SHIPADDR1 Character 30 215 244 13 SHIPADDR2 Character 30 245 274 14 SHIPCITY Character 22 275 296 15 SHIPSTATE Character 2 297 298 16 SHIPZIP Character 10 299 308 17 SHIPPHONE Character 14 309 322 18 DATE Date 8 323 330 19 ETA Date 8 331 338 20 SUBTOTAL Numeric 10 2 339 348 21 TAXES Numeric 10 2 349 358 22 ADJUST Numeric 10 2 359 368 23 FREIGHT Numeric 10 2 369 378 24 PAID Numeric 10 2 379 388 25 TERMS Character 20 389 408 26 SHIPPER Character 20 409 428 27 BY Character 30 429 458 28 OPEN Logical 1 459 459 29 PRINTED Logical 1 460 460 30 CLASS Character 3 461 463 31 CONTROL Character 10 464 473 32 COMMENT Character 50 474 523 ────────── ───── Total 524 Structure for database: REC.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 KEY Numeric 6 1 6 2 PO Numeric 6 7 12 3 VENDOR Character 10 13 22 4 ITEM Character 12 23 34 5 DESC Character 30 35 64 6 VENDITEM Character 12 65 76 7 RECEIVED Numeric 7 77 83 8 COST Numeric 10 2 84 93 9 DATE Date 8 94 101 10 BY Character 30 102 131 11 PC Logical 1 132 132 12 COSTADJ Numeric 10 2 133 142 ────────── ───── Total 143 DAYO Inventory, TJS LAB Page: 109 Structure for database: VENDORS.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 VENDOR Character 10 1 10 2 NAME Character 30 11 40 3 ATTN Character 30 41 70 4 ADDR1 Character 30 71 100 5 ADDR2 Character 30 101 130 6 CITY Character 22 131 152 7 STATE Character 2 153 154 8 ZIP Character 10 155 164 9 PHONE Character 14 165 178 10 SHIPNAME Character 30 179 208 11 SHIPADDR1 Character 30 209 238 12 SHIPADDR2 Character 30 239 268 13 SHIPCITY Character 22 269 290 14 SHIPSTATE Character 2 291 292 15 SHIPZIP Character 10 293 302 16 SHIPPHONE Character 14 303 316 17 TERMS Character 20 317 336 18 SHIPPER Character 20 337 356 19 DATE Date 8 357 364 20 LASTDATE Date 8 365 372 21 FED_ID Character 15 373 387 22 TAXRATE Numeric 6 4 388 393 23 TYPE Character 3 394 396 24 CLASS Character 3 397 399 25 OPEN_PURC Numeric 10 2 400 409 26 RECV_PURC Numeric 10 2 410 419 27 TOT_PURC Numeric 10 2 420 429 28 DUE Numeric 10 2 430 439 29 PAID Numeric 10 2 440 449 30 TOTALPAID Numeric 10 2 450 459 31 FAX Character 14 460 473 32 ACCOUNT Character 12 474 485 33 COMMENT Character 50 486 535 ────────── ───── Total 536 DAYO Inventory, TJS LAB Page: 110 Structure for database: WAREHOUS.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 ITEM Character 12 1 12 2 LOC1 Numeric 7 13 19 3 SLLOC1 Numeric 7 20 26 4 LOC2 Numeric 7 27 33 5 SLLOC2 Numeric 7 34 40 6 LOC3 Numeric 7 41 47 7 SLLOC3 Numeric 7 48 54 8 LOC4 Numeric 7 55 61 9 SLLOC4 Numeric 7 62 68 10 LOC5 Numeric 7 69 75 11 SLLOC5 Numeric 7 76 82 12 LOC6 Numeric 7 83 89 13 SLLOC6 Numeric 7 90 96 14 LOC7 Numeric 7 97 103 15 SLLOC7 Numeric 7 104 110 ────────── ───── Total 111 Structure for database: WARENAME.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 LOC Character 10 1 10 2 NAME Character 30 11 40 3 COMMENTS Character 40 41 80 ───── ────────── ───────── ───── ─── ───── ─── Total 81 DAYO Inventory, TJS LAB Page: 111 ■ DATA DICTIONARY Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── ACCOUNT C 12 0 VENDORS.DBF Vendors account number for your company ADDR1 C 30 0 POH.DBF 1st line of the vendors address VENDORS.DBF ADDR2 C 30 0 POH.DBF 2nd line of the vendors address VENDORS.DBF ADJUST N 10 2 POH.DBF Amount of miscellaneous costs. Added by user to the purchase order header record ALLOCATED N 7 0 INV.DBF Qty on Work Orders ATTN C 30 0 POH.DBF The person/contact to receive the purchase order. AVGCOST N 10 2 INV.DBF Average cost BO N 7 2 INV.DBF BackOrder quantity (used with DAYO BO and DAYO POS) BOM L 1 0 INV.DBF Flag to denote Manufactured Item BY C 30 0 POH.DBF The user that create the purchase REC.DBF order, received items, and/or make INVADJ.DBF an inventory adjustment CITY C 22 0 VENDORS.DBF Vendors city POH.DBF CLASS C 3 0 VENDORS.DBF Vendors classification. INV.DBF Your classification of the item POD.DBF Vendor classification INVADJ.DBF COMMENT C 50 0 POH.DBF Purchase order comment. This comment will print on the purchase order form COMMENTS C 40 0 WARENAME.DBF A comment field for anything you POH.DBF want VENDORS.DBF COST N 10 2 INVADJ.DBF Cost of an item POD.DBF REC.DBF INV.DBF COSTADJ N 10 2 REC.DBF Cost adjustment value. Used only by the computer DATE D 8 0 INV.DBF Date item added to inventory INVADJ.DBF Date of adjustment VENDORS.DBF Date vendor created POD.DBF Date of purchase order detail line REC.DBF Date of receipt of item POH.DBF Date of purchase order header line DESC C 30 0 POD.DBF Description of item INV.DBF REC.DBF DESC2 C 30 0 INV.DBF 2nd Description DOLLARS N 10 2 INVADJ.DBF Total amount of adjustment DUE N 10 2 VENDORS.DBF Amount still due (balance due to Vendor) DAYO Inventory, TJS LAB Page: 112 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── ETA D 8 0 POH.DBF Estimated Time (date) of Arrival POD.DBF FREIGHT N 10 2 POH.DBF Amount charged for freight ITEM C 12 0 POD.DBF Unique item identifier WAREHOUS.DBF REC.DBF INVADJ.DBF INV.DBF KEY N 6 0 REC.DBF The RECEIVER/Key Rec number LASTDATE D 8 0 INV.DBF Last sale date VENDORS.DBF Last activity date LASTRECV D 8 0 POD.DBF Date of last receipt LOCATION C 3 0 INV.DBF Physical location of an item in the main warehouse LOC C 10 0 WARENAME.DBF Field Name of a warehouse/ location, ie 'LOC1' LOC1 N 7 0 WAREHOUS.DBF Quantity in warehouse # 1 LOC2 N 7 0 WAREHOUS.DBF Quantity in warehouse # 2 LOC3 N 7 0 WAREHOUS.DBF Quantity in warehouse # 3 LOC4 N 7 0 WAREHOUS.DBF Quantity in warehouse # 4 LOC5 N 7 0 WAREHOUS.DBF Quantity in warehouse # 5 LOC6 N 7 0 WAREHOUS.DBF Quantity in warehouse # 6 LOC7 N 7 0 WAREHOUS.DBF Quantity in warehouse # 7 NAME C 30 0 WARENAME.DBF Name of the warehouse/location VENDORS.DBF Name of the Vendor POH.DBF ONHAND N 7 0 INV.DBF Main warehouse quantity (INV.DBF) ONORDER N 7 0 INV.DBF Quantity currently on order with vendors (open purchase orders) OPEN L 1 0 POH.DBF Purchase order not filled/received POD.DBF if .F. OPEN_PURC N 10 2 VENDORS.DBF Amount (dollars) of open purchase orders for a vendor ORDERED N 7 0 POD.DBF Quantity originally ordered from vendor PACKQTY C 6 0 INV.DBF Descriptive Pack/Bundle Qty ie: '14 per' or '6 Pack' PAID N 10 2 POH.DBF Amount paid on this PO VENDORS.DBF Amount paid to a Vendor PC L 1 0 APH.DBF Purchase Clearing flag REC.DBF PHONE C 14 0 POH.DBF Vendors telephone number VENDORS.DBF PO N 6 0 REC.DBF Purchase Order (PO) number POH.DBF POD.DBF PRICE N 10 2 INVADJ.DBF Cost to your customers INV.DBF DAYO Inventory, TJS LAB Page: 113 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── PRICE1 N 10 2 INV.DBF Multiple Price #1 PRICE2 N 10 2 INV.DBF Multiple Price #2 PRICE3 N 10 2 INV.DBF Multiple Price #3 PRICE4 N 10 2 INV.DBF Multiple Price #4 PRICE5 N 10 2 INV.DBF Multiple Price #5 PRINTED L 1 0 POH.DBF PO has been printed (.T.) QTY N 7 0 INVADJ.DBF Inventory adjustment quantity REALCOST N 10 2 INV.DBF Real cost (includes freight and adjustments) REASON C 30 0 INVADJ.DBF Reason for an inventory adjustment RECEIVED N 7 0 REC.DBF Quantity of items received POD.DBF RECV_PURC N 10 2 VENDORS.DBF Amount (dollars) of closed/filled purchase orders RETAIL N 10 2 INV.DBF List price, manufacturers INVADJ.DBF recommended sale price SERIALNO L 1 0 INV.DBF If .T., the requires a serial number (not used by this version) SHIPPER C 20 0 POH.DBF Method of shipping VENDORS.DBF SHIPNAME C 30 0 VENDORS.DBF Ship To Name and address... POH.DBF SHIPADDR1 C 30 0 VENDORS.DBF POH.DBF SHIPADDR2 C 30 0 VENDORS.DBF POH.DBF SHIPCITY C 22 0 VENDORS.DBF POH.DBF SHIPSTATE C 2 0 VENDORS.DBF POH.DBF SHIPZIP C 10 0 VENDORS.DBF POH.DBF SHIPPHONE C 14 0 VENDORS.DBF POH.DBF SLLOC1 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #1 SLLOC2 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #2 SLLOC3 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #3 SLLOC4 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #4 SLLOC5 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #5 SLLOC6 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #6 SLLOC7 N 7 0 WAREHOUS.DBF Stocking Level for warehouse #7 SOLDPTD N 7 0 INV.DBF Total quantity sold for any given period SOLDYTD N 7 0 INV.DBF Total quantity sold for the year STATE C 2 0 VENDORS.DBF Vendors state address POH.DBF STOCKLEVEL N 7 0 INV.DBF Recommended inventory stocking level (user maintained in this version of DAYO Inventory) DAYO Inventory, TJS LAB Page: 114 Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── SUBTOTAL N 10 2 POH.DBF Subtotal of detail line items TAXABLE L 1 0 INV.DBF If .T., than item is taxable POD.DBF (user maintained) TAXES N 10 2 POH.DBF Total amount of taxes for a PO TERMS C 20 0 VENDORS.DBF Terms of repayment (ie: Net 10, POH.DBF C.O.D., Cash...) TOTALPAID N 10 2 VENDORS.DBF Total amount paid to this Vendor TOT_PURC N 10 2 VENDORS.DBF Total Purchases (History) TRANSACT C 12 0 INVADJ.DBF GL Transaction number TYPE C 3 0 VENDORS.DBF User maintained INV.DBF POD.DBF UNIT C 3 0 INV.DBF Unit of issue, ie EA, BOX, KIT UNITQTY N 7 0 INV.DBF Number of items per UNIT. This qty is used on purchase orders for the benefit of your vendor VENDITEM C 12 0 POD.DBF Vendor or manufacture item number REC.DBF INVADJ.DBF INV.DBF VENDOR C 10 0 POD.DBF Vendor code VENDORS.DBF INV.DBF REC.DBF POH.DBF WEIGHT N 8 2 INV.DBF Weight of the Item ZIP C 10 0 POH.DBF Vendors zip code VENDORS.DBF DAYO Inventory, TJS LAB Page: 115 ■ TJS 'Computer' LAB TJS LAB is an association of programmers and technicians that produce customized, multiuser software for the PC based network (ie: Novell and others). Our specialties include Inventory Control, PC Communications/EDI, Management, Reports (standard and graphic), Data Conversions, and Accounting (A/R, A/P). A unique feature of TJS LAB is that our software is by default, multiuser. 'Standalone' applications are the exception! All our applications are written in Clipper, Basic, or C (preferably Basic or Clipper). We will license all our application source codes. We produce applications that work, are easy to use, and are inexpensive! Want a change? Want an enhancement! Want a completely new product/application? Want to make your idea a reality? Custom/contract programming, by TJS LAB, and our associates is available. Standard rate is $50.00 per hour (our sites). Guaranteed quality and timely work is our number one policy. Write us at: TJS LAB PO Box 585366 Orlando, Florida 32858-5366 Or call us (9:00 am - 11:00 pm): (407) 291-3960 * Note that TJS LAB, nor any of the associates accept/take any support calls for unregistered products.